• Another way is to use :

    select * from sys.dm_db_missing_index_details