Interested to Buy Any Domain ? << Click Here >> for more details...
How does indexing improve query performance?
- 4 Answers
- 21013 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
Explain the term 'row' related to relational database management system?
what is object level locking ? where do appear this type of locking ?
What is a node in teradata? Explain
What do you mean by caching in teradata?
Can we collect statistics on multiple columns?
Explain and compare pros and cons of start schemas?
How do you do backup and recovery in teradata?
What do you mean by tpt in teradata?
Define views in teradata with general syntax.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the advantages of teradata?
How is MLOAD Teradata Server restarted after execution?
Highlight the need for Performance Tuning.
How do you see a ddl for an existing table?
What is the multi-insert?
