Developing SQL Databases — Question 152
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You need to identify the indexes that are not being used so that you can remove them from the database.
Solution: You run the sys.dm_db_index_usage_stats dynamic management view.
Does the solution meet the goal?
Answer options
- A. Yes
- B. No
Correct answer: A
Explanation
The correct answer is Yes because the sys.dm_db_index_usage_stats view provides information on how often indexes are used, allowing you to identify and subsequently remove unused indexes. The alternative answer, No, is incorrect as it does not recognize the value of the dynamic management view in achieving the goal of index identification.