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
How to Extract data from multiple legacy systems?
Which is faster fastload or multiload?
What is the command in bteq to check for session settings ?
Which is more efficient group by or distinct to find duplicates?
What is the purpose of upsert command?
What do you mean by teradata intelliflex?
What are types of partition primary index (ppi) in teradata?
What is a node in teradata?
Explain the term 'columns' related to relational database management system?
Explain fallback in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is a dimension table?
What is meant by a Highest Cost Plan?
List the logical and conditional operators that are used with teradata along with their meanings?
Explain BYNET.