How Is Index Tuning Used To Improve Query Performance?

1.	How Is Index Tuning Used To Improve Query Performance?
Answer» The Index tuning wizard can be used to improve the performance of queries and databases. It uses the following MEASURES to do so: It uses the query optimizer to perform the analysis of queries with respect to the workload and based on this knowledge, it recommends the best USAGE of indexes. The CHANGES in the usage of index, query distribution and their performance are analysed for checking the EFFECT. It also recommends ways of tuning the database for a small set of problem queries. The Index tuning wizard can be used to improve the performance of queries and databases. It uses the following measures to do so:

Answer»

The Index tuning wizard can be used to improve the performance of queries and databases. It uses the following MEASURES to do so:

It uses the query optimizer to perform the analysis of queries with respect to the workload and based on this knowledge, it recommends the best USAGE of indexes.
The CHANGES in the usage of index, query distribution and their performance are analysed for checking the EFFECT.
It also recommends ways of tuning the database for a small set of problem queries.

The Index tuning wizard can be used to improve the performance of queries and databases. It uses the following measures to do so:

Discussion