Advertisements
Advertisements
प्रश्न
Give any two measures to achieve index hunting.
थोडक्यात उत्तर
Advertisements
उत्तर
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
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
