Developing SQL Databases — Question 153
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_physical_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 sys.dm_db_index_physical_stats provides information about index fragmentation and page density, but it does not indicate whether an index is unused. To identify unused indexes, one should query the sys.dm_db_index_usage_stats view, which tracks index usage statistics.