Developing SQL Databases — Question 123
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_operational_stats dynamic management view.
Does the solution meet the goal?
Answer options
- A. Yes
- B. No
Correct answer: B
Explanation
The solution does not meet the goal because the sys.dm_db_index_operational_stats view provides information about index usage but does not specifically identify unused indexes. To find unused indexes, the sys.dm_db_index_usage_stats view should be used instead, which tracks the number of times indexes are used for reads and writes.