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 the functions performed by bynet?
What is bteq utility in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the various indexes in teradata? Why are they preferred?
How would you load a very large file in teradata in general?
What tools would you use for that?
Explain fastload in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are tpump utility limitations?
Describe the between keyword in teradata?
Explain amp in teradata?
Describe primary index in teradata?
What is primary index and secondary index?
What do you mean by teradata intellicloud?
What is multi insert?