what is use of PI(primary index) AND SI(secondary index)
- 2 Answers
- 6365 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 do you define Teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the functions performed by bynet?
How to load specific no.of records using bteq, or fastload,or multiload
What is the basic syntax for teradata select statement?
if collect stats but it show low confidence why?
Explain the teradata primary index mechanics in detail with a diagram.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is spool space? Why do you get spool space errors?
What are the available join types in teradata?
What tools would you use for that?
What is dimensional modeling?
Why are oltp database designs not generally a good idea for a data warehouse?
What is the opening step in basic teradata query script?
