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 5 phases in a multiload utility?
Explain the term 'columns' related to relational database management system?
How do you determine the number of sessions?
What is stored procedure in teradata?
Highlight all the modes that are present under Confidence Level.
Difference between inner join and outer join?
What's the difference between timestamp (0) and timestamp (6)?
What are the steps involved after the disk manager passes the request?
How many sessions of MAX is PE capable of handling at a particular time?
What do you mean by caching in teradata?
What is meant by a dispatcher?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is primary index and secondary index?
What are the various indexes in teradata? Why are they preferred?
Difference between star and snowflake schemas?