You administer a Microsoft SQL Server server. You plan to deploy new features to an application.
You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.
What should you do?
A. Query the sys.dm_db_index_usage_stats DMV.
B. Query the sys.dm_db_missing_index_details DMV.
C. Use the Database Engine Tuning Advisor.
D. Query the sys.dm_db_missing_index_columns DMV.
You administer a Microsoft SQL Server server. You plan to deploy new features to an application. You need to evaluate ex
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You administer a Microsoft SQL Server server. You plan to deploy new features to an application. You need to evaluate ex
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!