How index hunting contributes in improving the query performance?

Index hunting is viewed as an important part of database management system. It enhances the speed and the query performance of the database. It is done in following ways-

• In order to coordinate the study of query with workload, query optimizer is used. It also suggests the best use of queries based on the optimizer.
• Performance of query distribution is checked and monitored to know there effects.
• Turning complex database into small chunks of queries is also suggested.