How does indexing improve query performance?
Answer Posted / yuvaevergreen
PI is very important in TD, because the data distribution
is basically dependent on PI.
1.Data distribution
2.Fastest way to retrieve rows
3.Important for joins
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the functions involved in shared information architecture?
What is the primary index in teradata?
How can bottlenecks be identified?
What tools would you use for that?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
How to run a query in teradata?
Describe the between keyword in teradata?
What is TPD?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
If RDBMS is halted what will you do ?
What is oltp?
What are the uses of client software involved in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the different functions included in the server software?