Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7247 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
Difference between star and snowflake schemas?
What is meant by a dispatcher?
Steps to create a data model?
Why is the case expression used in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Explain Teradata performance tuning and optimization?
What is called partitioned primary index (ppi)?
how many modules are there in telecome domain?how to explain the architecture?
How do you verify a complicated sql?
any one answer me how they can analyzing the project using data ware housing?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How to select first n records in teradata?
What are the available primary index types?
Why teradata is used?
What is the use of teradata system software?
