How Does Index Hunting Help In Improving Query Performance?

1.	How Does Index Hunting Help In Improving Query Performance?
Answer» Index hunting helps in improving the speed as WELL as the QUERY performance of database. The followed measures are achieved to do that: The query optimizer is used to coordinate the study of queries with the workload and the best USE of queries suggested based on this. Index, query distribution along with their performance is observed to check the effect. Tuning databases to a small collection of problem queries is also RECOMMENDED. Index hunting helps in improving the speed as well as the query performance of database. The followed measures are achieved to do that:

Answer»

Index hunting helps in improving the speed as WELL as the QUERY performance of database. The followed measures are achieved to do that:

The query optimizer is used to coordinate the study of queries with the workload and the best USE of queries suggested based on this.
Index, query distribution along with their performance is observed to check the effect.
Tuning databases to a small collection of problem queries is also RECOMMENDED.

Index hunting helps in improving the speed as well as the query performance of database. The followed measures are achieved to do that:

Discussion