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 'tables' related to relational database management system?
What is the purpose of indexes?
How do you verify a complicated sql?
Explain the meaning of Amp?
List out all forms of LOCKS that are available in Teradata.
What are the various indexes in teradata? Why are they preferred?
What do you mean by tpt in teradata?
What are the multiload utility limitations?
How you will check the version of teradata?
What is the command in bteq to check for session settings ?
Can we collect statistics on table level?
What is the use of stored procedures in teradata?
What are differences between teradata and ansi session modes in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain the teradata primary index mechanics in detail with a diagram.