|
Database index tuning - August 29, 2008 at 18:00 PM by Amit Satpute
What is Index tuning?
Query performance as well as speed improvement of a database can be done using
Indexes.
The process of enhancing the selection of indexes is called Index Tuning.
How is index tuning used to improve query performance?
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.
|