How does indexing improve query performance?
Answer Posted / guru
ONE LINE ANSWER: INdexing acts as SET option (Where clause)
while an query is being executed provided the query
contains these indexes.
Guru,
Advanced Teradata Certified Professional
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is a level of granularity of a fact table?
What are the various indexes in teradata?
Explain Teradata performance tuning and optimization?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the use of fallback?
What is the multi-insert?
Describe primary index in teradata?
What do you mean by ttu in teradata?
What is the maximum number of dml can be coded in a multiload script?
What is real time and near real time data warehousing?
What are the joins in teradata?
How to find duplicates in a table?
What are the design features involved in teradata?
What is the difference between teradata and basic rdbms?
What does Amp contain and what are all the operations that it performs?