Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8793 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 are some commonly used bteq scripts?
What is meant by a Highest Cost Plan?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What do you mean by ttu in teradata?
how can we analyze the locks ?
What are the enhanced features in teradata v2r5 and v2r6?
Explain about Skew Factor?
Syntax for case when statement?
What is the difference between teradata and oracle?
where we can use the delimiter in mload? pls let me know
Why do you get spool space errors? How do trouble-shoot them?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
Teradata 
