MSSql – Identify Missing Indexes

select * from
(select user_seeks * avg_total_user_cost * (avg_user_impact * 0.01) as index_advantage,
migs.* from sys.dm_db_missing_index_group_stats migs) as migs_adv
inner join sys.dm_db_missing_index_groups as mig on migs_adv.group_handle=
mig.index_group_handle
inner join sys.dm_db_missing_index_details as mid on mig.index_handle=mid.index_handle
order by migs_adv.index_advantage

If ‘index_advantage’ > 5000 evalutate,
If ‘index_advantage’ > 10000 create the index.