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
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
