How does indexing improve query performance?
Answer Posted / praveen
By creating index on single or multiple columns, query
takes index access path instead of full table scan. Full
table scan is costilier operation where it has to visit all
rows in the table whereas index operation just accesses the
index sub table with required hash value and joins with the
basetable using rowid. This improves response time and
performance of the query.
Is This Answer Correct ? | 28 Yes | 3 No |
Post New Answer View All Answers
What can be achieved by using the teradata rdbms?
What are the different design perspectives used in teradata?
Explain Teradata performance tuning and optimization?
What is spool space? Why do you get spool space errors?
What is meant by a Clique?
Name the five phases that come under MultiLoad Utility.
Syntax for case when statement?
Is multi insert ansi standard?
Difference between stored procedure and macro?
Difference between inner join and outer join?
Explain the most common data types used in teradata?
What does Amp contain and what are all the operations that it performs?
how can we analyze the locks ?
What is smp and mpp platforms?
What are the functions of a Parser?