Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8627 Views
- IBM, I also Faced
- E-Mail Answers
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 do high confidence, low confidence and no confidence mean in explain plan?
What is meant by a Clique?
Why teradata is used?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
How to Extract data from multiple legacy systems?
Name the five phases that come under MultiLoad Utility.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
what is use of fload loading into set table?
What are the components provided on node?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Discuss the advantages of using partitioned primary index in a query?
What is Join Index in TD and How it works?
Teradata 
