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
any one answer me how they can analyzing the project using data ware housing?
How to eliminate product joins in a teradata sql query?
What are the main components of teradata system?
Explain amp in teradata?
Comment whether bottleneck is an error or not.
How to select first n records in teradata?
Explain vproc in teradata?
Difference between multiload and tpump?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is the meaning of Caching in Teradata?
What is the function of parser component in teradata?
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 do you mean by teradata sql assistant?
Explain and compare pros and cons of snow flake schemas?
Explain the term 'row' related to relational database management system?