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
Explain the term 'row' related to relational database management system?
What is meant by a Clique?
What are some commonly used bteq scripts?
What are the functions of a teradata dba?
Describe the between keyword in teradata?
Highlight the need for Performance Tuning.
Describe primary index in teradata?
What is the primary index in teradata?
What are the newly developed features of Teradata?
What are the updated features of teradata?
What is multi insert?
During the Display time, how is the sequence generated by Teradata?
how do you manage the production space. what are the proactive methods you can take ?
what are the uses of fact table and dimension table in banking project?
What is a three-tier data warehouse?