what is use of PI(primary index) AND SI(secondary index)
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 Clique?
How to Extract data from multiple legacy systems?
What is the function of parser component in teradata?
Highlight all the modes that are present under Confidence Level.
List out all forms of LOCKS that are available in Teradata.
What are the scenarios in which full table scans occurs?
List out some of the primary characteristics of teradata.
Comment whether bottleneck is an error or not.
Explain BYNET.
Explain the term 'columns' related to relational database management system?
what are the day to day activities of teradata DBA ?
What are the various indexes in teradata? Why are they preferred?
What are the updated features of teradata?
if collect stats but it show low confidence why?
Explain teradata vs. Redshift?