How does index hunting help in improving query performance?



How does index hunting help in improving query performance?..

Answer / Babli

Index hunting is the process of finding the most suitable index to use for a specific SQL query. Using appropriate indexes can significantly improve the performance of queries by reducing the number of disk reads required.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

In DBMS, what are the two integrity rules used?

1 Answers   TCS,


What is progress open edge?

1 Answers  


What are the steps involved in Instance Recovery ?

1 Answers   ibcs primax,


How do I create a database in open office?

1 Answers  


What do you mean by entity type?

1 Answers  


What is file manager?

1 Answers  


With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

1 Answers   eBay,


How to schedule ssas database backup

1 Answers  


Mention a query to calculate the even and odd records from a table

1 Answers  


What do you understand by ‘database’?

1 Answers  


Explain the Logical Schema of Database

1 Answers   HCL,


Define primary and unique key?

1 Answers  


Categories