执行时间最长 sql 执行计划

SELECT TOP 10 qp.query_plan,qt.text,total_worker_time   
from sys.dm_exec_query_stats  
CROSS APPLY sys.dm_exec_sql_text(sql_handle) qt  
CROSS APPLY sys.dm_exec_query_plan(plan_handle) qp  
where qp.query_plan.exist('declare namespace   
qplan="http://schemas.microsoft.com/sqlserver/2004/07/showplan";  
            //qplan:RelOp[@LogicalOp="Index Scan"  
            or @LogicalOp="Clustered Index Scan"  
            or @LogicalOp="Table Scan"]')=1  
order by total_worker_time DESC
复制