Question

Give any two measures to achieve index hunting.

Answer 1

The followed measures are achieved to do that:

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