SQL语句实现查询并自动创建Missing Index
SELECT
migs.avg_total_user_cost*(migs.avg_user_impact/100.0)*(migs.user_seeks+migs.user_scans)ASimprovement_measure,
'CREATEINDEX[missing_index_'+CONVERT(varchar,mig.index_group_handle)+'_'+CONVERT(varchar,mid.index_handle)
+'_'+LEFT(PARSENAME(mid.statement,1),32)+']'
+'ON'+mid.statement
+'('+ISNULL(mid.equality_columns,'')
+CASEWHENmid.equality_columnsISNOTNULLANDmid.inequality_columnsISNOTNULLTHEN','ELSE''END
+ISNULL(mid.inequality_columns,'')
+')'
+ISNULL('INCLUDE('+mid.included_columns+')','')AScreate_index_statement,
migs.*,mid.database_id,mid.[object_id]
FROMsys.dm_db_missing_index_groupsmig
INNERJOINsys.dm_db_missing_index_group_statsmigsONmigs.group_handle=mig.index_group_handle
INNERJOINsys.dm_db_missing_index_detailsmidONmig.index_handle=mid.index_handle
WHEREmigs.avg_total_user_cost*(migs.avg_user_impact/100.0)*(migs.user_seeks+migs.user_scans)>10
ORDERBYmigs.avg_total_user_cost*migs.avg_user_impact*(migs.user_seeks+migs.user_scans)DESC热门推荐
10 读书祝福语女生短句简短
11 感谢同事新婚祝福语简短
12 感谢教官文案祝福语简短
13 员工聚会蛋糕祝福语简短
14 元宵发客户祝福语简短
15 给团队信心祝福语简短
16 医美的祝福语大全简短
17 异国姻缘的祝福语简短
18 兄妹拍照祝福语简短的话