What are the various indexes in teradata? Why are they preferred?


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

Post New Answer

More Teradata Interview Questions

Explain the advantages of partitioned primary index in a query?

0 Answers  


Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,


Why do Hash joins usually perform better than Merge Joins?

1 Answers  


What is the purpose of indexes?

0 Answers  


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

0 Answers  






Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  


What are differences between teradata and ansi session modes in teradata?

0 Answers  


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

0 Answers  


What is the default join strategy in Teradata???

5 Answers   IBM,


In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,


If the script is aborted. why it is aborted and how can you identify ?

1 Answers  


What is a node in teradata?

0 Answers  


Categories