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热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下