Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7388 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 meant by a Virtual Disk?
List out teradata data types?
Explain teradata architecture?
What are the uses of bynets in multi-node systems?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain fallback in teradata?
How you will check the version of teradata?
What are tpump utility limitations?
What is TPD?
Write a program to show the parser component used in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What is meant by a Parsing Engine?
What is oltp?
What are aggregate tables? How do you design them using teradata?
What is the difference between teradata and basic rdbms?
