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
Explain the term 'primary key' related to relational database management system?
How do you set the session mode parameters in bteq?
What is oltp?
How many types of joins are there in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain teradata utilities. What is multiload, fast load, tpump?
How do you determine the number of sessions?
Explain the types of join supports by teradata?
How is the teradata different from oracle?
What is meant by a node?
Explain teradata architecture?
Explain Teradata performance tuning and optimization?
What is inner join and outer join?
How to eliminate product joins in a teradata sql query?
What is the meaning of Caching in Teradata?