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 are tpump utility limitations?
How to Extract data from multiple legacy systems?
Explain the teradata primary index mechanics in detail with a diagram.
What are some primary characteristics of teradata?
Why is the case expression used in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
In Teradata, what is the significance of UPSERT command?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
How many codd's rules are satisfied by teradata database?
If RDBMS is halted what will you do ?
What is the multi-insert?
What is meant by a Least Cost Plan?
How is the teradata different from oracle?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?