[MS-SQL] 실행계획 확인 / 속도 저하

SELECT cp.refcounts
         ,cp.usecounts
         ,cp.objtype
         ,st.dbid
         ,st.objectid
         ,st.text
         ,qp.query_plan
FROM SYS.dm_exec_cached_plans cp
CROSS APPLY SYS.dm_exec_sql_text(cp.plan_handle)st
CROSS APPLY SYS.dm_exec_query_plan(cp.plan_handle)qp