Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7263 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 teradata makes sure that there are no duplicate rows being inserted when its a set table?
What happens in a conflict? How do you handle that?
What happens when a node suffers a downfall?
Differentiate primary key and partition key?
What is the basic syntax for teradata select statement?
Describe the set operators in teradata.
How is MLOAD Teradata Server restarted after execution?
Steps to create a data model?
What is teradata?
How to select first n records in teradata?
Explain the meaning of Amp?
What are the various indexes in teradata? Why are they preferred?
Why is the case expression used in teradata?
Describe primary index in teradata. And what are the available primary index types?
What are the various reporting tools in the market?
