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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is multi insert?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the advantages of teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is a sparse index?
Syntax for case when statement?
What are the joins in teradata and how many types of joins are there in teradata?
What are the joins in teradata?
How to identify ppi columns?
What is the opening step in basic teradata query script?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is bteq utility in teradata?
What are the various indexes in teradata? How to use them?
What do you mean by teradata intelliflex?