Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8796 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 |
why should we go Teradata over Oracle,what is the main differences?
How is the teradata different from oracle?
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 various indexes in teradata?
Highlight the points of differences between the database and user in Teradata.
Explain the term 'columns' related to relational database management system?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
What is logical data model?
Explain BYNET.
What are the various indexes in teradata? Why are they preferred?
What is multi insert?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
Teradata 
