CHARPTER 3--INDEX DMVs
摘要：
1.查找最重要的缺失的索引 --=======================================================--查找最重要的缺失的索引SELECT TOP(20)DB_NAME() AS DBName,ROUND(s.avg_total_user_cost*s.avg_user_impact*(S.user_seeks+S.user_scans),0) AS [TotalCost],D.[statement] AS TableName,D.equality_columns,D.inequality_columns,D.included_columnsINTO 阅读全文
posted @ 2014-02-24 23:08 笑东风 阅读(265) 评论(2) 推荐(0) 编辑
