SQL Server 优化

最新推荐文章于 2020-12-02 20:00:38 发布

weixin_30699831

最新推荐文章于 2020-12-02 20:00:38 发布

阅读量111

点赞数

原文链接：http://www.cnblogs.com/ilookbo/p/10700651.html

版权

SELECT  TOP 10 
        [Total Cost]  = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0) 
        , avg_user_impact
        , TableName = statement
        , [EqualityUsage] = equality_columns 
        , [InequalityUsage] = inequality_columns
        , [Include Cloumns] = included_columns
FROM        sys.dm_db_missing_index_groups g 
INNER JOIN    sys.dm_db_missing_index_group_stats s 
       ON s.group_handle = g.index_group_handle 
INNER JOIN    sys.dm_db_missing_index_details d 
       ON d.index_handle = g.index_handle
ORDER BY [Total Cost] DESC;

转载于:https://www.cnblogs.com/ilookbo/p/10700651.html