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
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is the purpose of using case expression in teradata?
What are normalization, first normal form, second normal form and third normal form?
Differentiate database data and data warehouse data?
What do you mean by ttu in teradata?
What is inner join and outer join?
What is oltp?
Explain and compare pros and cons of start schemas?
How can you track login parameters of users in teradata?
How to select first n records in teradata?
What is node? How many nodes and amps used in your previous project?
How do you determine the number of sessions?
What is the use of stored procedures in teradata?
What is stored procedure in teradata?
What do you mean by teradata sql assistant?