摘要: 查找缺失索引:SELECT migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure, 'CREATE INDEX [missing_index_' + CONVERT (varchar, mig.index_group_handle) + '_' + CONVERT (varchar, mid.index_handle) + '_' + LEFT (PARSENAME 阅读全文
posted @ 2013-04-11 18:02 快活杰 阅读(385) 评论(0) 推荐(0) 编辑