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 are the design features involved in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
Define views in teradata with syntax.
What are default access rights in teradata? What explicit right can be given to a user?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
write lock is compatiable with which type of lock?
any one answer me how they can analyzing the project using data ware housing?
Differentiate primary key and partition key?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the components used in smp and massively parallel processing (mpp) machines?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?