SQL 效率问题~

查询缺失索引：

SELECT
     DatabaseName = DB_NAME(database_id)
      ,[Number Indexes Missing] = count(*)
  FROM sys.dm_db_missing_index_details
  GROUP BY DB_NAME(database_id)
  ORDER BY 2 DESC;
  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

查询CPU：

SELECT TOP 10 TEXT AS 'SQL Statement'
    ,last_execution_time AS 'Last Execution Time'
    ,(total_logical_reads + total_physical_reads + total_logical_writes) / execution_count AS [Average IO]
    ,(total_worker_time / execution_count) / 1000000.0 AS [Average CPU Time (sec)]
    ,(total_elapsed_time / execution_count) / 1000000.0 AS [Average Elapsed Time (sec)]
    ,execution_count AS "Execution Count",qs.total_physical_reads,qs.total_logical_writes
    ,qp.query_plan AS "Query Plan"
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY total_elapsed_time / execution_count DESC

Sql 开性能：
https://blog.csdn.net/qq_25744257/article/details/81189288

SQL 看哪步消耗时间：
在sqlserver Management studio中，选对目标库，然后ctrl+M，然后执行你这个语句