what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 6349 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 are the available primary index types in teradata.
What is the difference between union and union all in teradata?
What is a level of granularity of a fact table?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the functions of a Parser?
What are the steps involved after the disk manager passes the request?
What is a three-tier data warehouse?
What are the various indexes in teradata? Why are they preferred?
What is TPD?
Highlight a few of the important components of Teradata?
Explain teradata vs. Redshift?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Difference between stored procedure and macro?
Which is faster fastload or multiload?
How do you define Teradata?
