天天看点

Explanation for Sys.dm_db_missing_index_group_stats DMV return columns

http://sqlserverpedia.com/wiki/DM_Objects_-_Sys.dm_db_missing_index_group_stats

Sys.dm_db_missing_index_group_stats DMV returns statistical information about estimated improvement each missing index could provide once implemented. The following table explains columns returned by this DMV:

Column Name Explanation
Group_handle Index group identifier. You can use this column to join sys.dm_db_missing_index_group_stats to sys.dm_db_missing_index_gropus DMV.
Unique_compiles Total number of times any query that would benefit from the missing index was compiled or recompiled.
User_seeks Number of seeks caused by the queries that would benefit from the missing index.
User_scans Number of scans caused by the queries that would benefit from the missing index.
Last_user_seek Date and time of the last seek caused by a query that could benefit from the missing index.
Last_user_scan Date and time of the last scan caused by a query that could benefit from the missing index.
Avg_total_user_cost Average cost of user queries that would be reduced by the missing index.
Avg_user_impact Estimated average performance improvement for each query that would benefit from the missing index.
System_seeks Number of seeks caused by the system operations, such as updating statistics that would benefit from the missing index.
System_scans Number of scans caused by the system operations, such as updating statistics that would benefit from the missing index.
Last_system_seek Date and time of the last seek caused by a system operation that could benefit from the missing index.
Last_system_scan Date and time of the last scan caused by a system operation that could benefit from the missing index.
Avg_total_system_cost Average cost of system queries that would benefit from the missing index.
Avg_system_impact Estimated average performance improvement for each system query that benefit from the missing index.

继续阅读