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
Why are oltp database designs not generally a good idea for a data warehouse?
What is the maximum number of dml can be coded in a multiload script?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the main components of teradata system?
How to identify ppi columns?
What do you mean by fastexport in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Discuss the advantages of using partitioned primary index in a query?
What do you mean by caching in teradata?
What is collect statistics?
Explain the advantages of partitioned primary index in a query?
What is oltp?
What is meant by Teradata Gateway?
What are the primary characteristics of the Teradata.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?