Interested to Buy Any Domain ? << Click Here >> for more details...
what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 7302 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
Define views in teradata with syntax.
How do you define Teradata?
What are some commonly used bteq scripts?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Describe the set operators in teradata.
Steps to create a data model?
Why managing the data is important?
Which is more efficient group by or distinct to find duplicates?
What type of indexing mechanism do we need to use for a typical data warehouse?
Why are oltp database designs not generally a good idea for a data warehouse?
What is the use of fallback?
What is the use of stored procedures in teradata?
What is the difference between teradata and oracle?
Can we collect statistics on table level?
What is the meaning of Caching in Teradata?
