Advertisements
Advertisements
Question
Give any two measures to achieve index hunting.
Answer in Brief
Solution
The followed measures are achieved to do that:
- The query optimizer is used to coordinate the study of queries with the workload and the best use of queries suggested based on this.
- Index, query distribution along their performance is observed to check the effect.
- Tuning databases to a small collection of problem queries is also recommended.
shaalaa.com
DBMS in Business Application
Is there an error in this question or solution?
RELATED QUESTIONS
How is index hunting helpful?
Give the difference between data and information along with an example.
Pick the odd one out.
Which one of the following terms is NOT related to computerised databases?
Which formula will capture the correct number of numerical values from the following range?
A2 : A5 & C2 : C5
Arrange the following in hierarchy to create a DBMS:
FIELD, DATA, FILE, RECORD
An index is clustered if:
