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


Please Help Members By Posting Answers For Below Questions

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1922


What is the purpose of using case expression in teradata?

774


What are normalization, first normal form, second normal form and third normal form?

837


Differentiate database data and data warehouse data?

796


What do you mean by ttu in teradata?

743


What is inner join and outer join?

825


What is oltp?

757


Explain and compare pros and cons of start schemas?

767


How can you track login parameters of users in teradata?

848


How to select first n records in teradata?

815


What is node? How many nodes and amps used in your previous project?

865


How do you determine the number of sessions?

816


What is the use of stored procedures in teradata?

774


What is stored procedure in teradata?

781


What do you mean by teradata sql assistant?

771