SQL Server – DMV to View Missing Indexes

--DMV to view missing indexes

SELECT​​ 

 *

FROM​​ 

 sys.dm_db_missing_index_group_stats​​ AS​​ igs

  JOIN​​ 

 sys.dm_db_missing_index_groups​​ AS​​ ig​​ ON​​ igs.group_handle​​ =​​ ig.index_group_handle

  JOIN​​ 

 sys.dm_db_missing_index_details​​ AS​​ id​​ ON​​ ig.index_handle​​ =​​ id.index_handle