Advertisement Remove all ads

Give any two measures to achieve index hunting. - Accounts

Advertisement Remove all ads
Advertisement Remove all ads
Answer in Brief

Give any two measures to achieve index hunting.

Advertisement Remove all ads

Solution

The followed measures are achieved to do that:

  1. The query optimizer is used to coordinate the study of queries with the workload and the best use of queries suggested based on this.
  2. Index, query distribution along their performance is observed to check the effect.
  3. Tuning databases to a small collection of problem queries is also recommended.
Concept: DBMS in Business Application
  Is there an error in this question or solution?
Advertisement Remove all ads
Advertisement Remove all ads
Share
Notifications

View all notifications


      Forgot password?
View in app×