what is the difference between primary index and secondary index?.
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Distribution of data in TD depends on primary index. SI is not involved in distribution of data. PI is mandatory whereas SI is optional. SI, if not chosen properly, is just an overhead.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / tdguy
PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.
Is This Answer Correct ? | 3 Yes | 0 No |
What is the purpose of indexes?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain parsing engine in teradata?
What is differnce between Error code and Error Level in Bteq
What is the opening step in basic teradata query script?
How to run a query in teradata?
What are the various indexes in teradata?
What is spool space?
What exactly do you know about catching in teradata?
Which is more efficient group by or distinct to find duplicates?
What is the syntax for case when statement?
How to find duplicates in a table?