Microsoft
70-433 · Question #34
You need to build CREATE INDEX statements for all the missing indexes that SQL Server has identified. Which dynamic management view should you use?
The correct answer is B. sys.dm_db_missing_index_details. sys.dm_db_missing_index_details returns detailed information about missing indexes, excluding spatial indexes.
Troubleshoot and Optimize Databases
Question
You need to build CREATE INDEX statements for all the missing indexes that SQL Server has identified. Which dynamic management view should you use?
Options
- Asys.dm_db_index_usage_stats
- Bsys.dm_db_missing_index_details
- Csys.dm_db_missing_index_columns
- Dsys.dm_db_missing_index_group_stats
How the community answered
(20 responses)- A5% (1)
- B80% (16)
- C5% (1)
- D10% (2)
Explanation
sys.dm_db_missing_index_details returns detailed information about missing indexes, excluding spatial indexes.
Topics
#missing indexes#dynamic management views#sys.dm_db_missing_index_details#index recommendations
Community Discussion
No community discussion yet for this question.