Interested to Buy Any Domain ? << Click Here >> for more details...
How does indexing improve query performance?
- 4 Answers
- 20994 Views
- Satyam, I also Faced
- E-Mail Answers
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
What do you mean by teradata intellicloud?
What are tpump utility limitations?
What is the difference between fastload and multiload?
Explain amp in teradata?
In Teradata, what is the significance of UPSERT command?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is logical data model?
What are the commands to make a new table, change a table and remove a table in teradata?
What is database exceptions in teradata?
What are the uses of bynets in multi-node systems?
What is bteq utility in teradata?
Explain the types of join supports by teradata?
What are the available join types in teradata?
How do you do backup and recovery in teradata?
What do you mean by teradata sql assistant?
