What is collect statistics?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

Describe primary index in teradata?

0 Answers  


When tpump is used instead of multiload?

0 Answers  


I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

0 Answers  


Difference between multiload and tpump?

0 Answers  






What is database exceptions in teradata?

0 Answers  


I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,


What is the difference between union and union all in teradata?

0 Answers  


Explain the meaning of Amp?

0 Answers  


Discuss the advantages of using partitioned primary index in a query?

0 Answers  


What happens when a node suffers a downfall?

0 Answers  


I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,


Categories