Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7488 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / tdguy
PI - mandatory and very important in TD. Useful in
distribution and retrieval. Performance of TD highly
depends on PI.
SI - Optional and provides alternate path to data. When
choosen appropriately, this improves the performance of
queries.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the basic syntax for teradata select statement?
Discuss the advantages of using partitioned primary index in a query?
What is primary index and secondary index?
In BTEQ, how are the session-mode parameters being set?
any one answer me how they can analyzing the project using data ware housing?
Explain vproc in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
List out teradata data types?
What is teradata? What are some primary characteristics of teradata?
Is multi insert ansi standard?
What is difference between user and database in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
In general, how do you optimze any sql in teradata?
