Question - How to improve query performance using Index hunting?
Answer -
Index hunting help in improving query performance by:
- Using a query optimizer to coordinate queries with the workload.
- Observing the performance and effect of index and query distribution.