Question

What Do You Mean By Index Hunting?

Answer 1

hunting?Indexes help in improving the speed as well as the query performance of database. Theprocedure of boosting the collection of indexes is named as Index hunting.30) How does Index hunting help in improving query performance?Index hunting helps in improving the speed as well as the query performance of database. Thefollowed measures are achieved to do that:The query optimizer is used to coordinate the study of queries with the workload and thebest 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.31) Enlist the disadvantages of query.The disadvantages of query are:No indexes5 / 10