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 are types of partition primary index (ppi) in teradata?
Highlight the points of differences between the database and user in Teradata.
What are the various indexes in teradata? How to use them?
What does sleep function does in fast load?
Explain the teradata primary index mechanics in detail with a diagram.
How is MLOAD Teradata Server restarted after execution?
Different phases of multiload?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain the parallel data extension in teradata?
If a Node is busy what are the steps you can take to avoid ?
What do you mean by tpt in teradata?
What is teradata and why it is used?
What is the use of teradata system software?
What are the things to be considered while creating secondary index?