Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7350 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
How can you track login parameters of users in teradata?
Explain parsing engine in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
Explain teradata utilities. What is multiload, fast load, tpump?
Explain fallback in teradata?
Highlight the advantages of PPI(Partition Primary Index).
Explain and compare pros and cons of start schemas?
What is the primary index in teradata?
What is meant by Teradata Gateway?
What is inner join and outer join?
Explain the types of join supports by teradata?
How to Extract data from multiple legacy systems?
What are the updated features of teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the available primary index types in teradata.
