Question - 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.