what is the difference between primary index and secondary index?.
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by teradata sql assistant?
What do you mean by teradata intellicloud?
What is the meaning of Caching in Teradata?
What are the primary characteristics of the Teradata.
What is logical data model?
Can we collect statistics on table level?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How many types of joins are there in teradata?
How does hashing happens in teradata?
Explain the types of join supports by teradata?
What is the use of having index on table?
What are the scenarios in which full table scans occurs?
What are the frequently used data types in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is meant by a Parsing Engine?