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 |
Can we load a Multi set table using MLOAD?
During the Display time, how is the sequence generated by Teradata?
what are the day to day activities of teradata DBA ?
How many types of index are present in teradata?
What are the available primary index types?
What are the different design perspectives used in teradata?
What are the steps to create a data model?
What are the frequently used data types in teradata?
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
What do you mean by ttu in teradata?
In Teradata, what is the significance of UPSERT command?
Highlight all the modes that are present under Confidence Level.