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.