1.

Define Index Hunting. What is it used for in Database Management Systems?

Answer»

Index HUNTING is the process of enhancing a collection of indices. The purpose of doing Index Hunting is that INDEXES make the performance of the QUERIES better and ALSO reduce the TIME required to process a query. Given below are the various ways in which Index Hunting improves the  performance of the queries:

  • The most optimal queries are suggested with the usage of the query optimizer.
  • For checking the effect, measurements such as index, query distribution, and performance are used.
  • Optimization is also done on the databases for a few of the problem queries.


Discussion

No Comment Found

Related InterviewSolutions