[2k] XML로 실행 계획 보기

1. /**********************************************************************************************
   -- Title : [2k] XML로 실행 계획 보기
   -- Reference : mcpworld.com
   -- Key word : showplan_xml statistics xml
   **********************************************************************************************/
   -- XML 실행 계획
   set showplan_xml on
   GO
   
   SELECT *
   FROM charge
   WHERE charge_amt < 3.0
   GO
   
   set showplan_xml off
   GO
   
   set statistics xml on -- 실제 실행 계획 포함
   GO
   
   SELECT * FROM charge
   WHERE charge_amt < 3.0
   GO
   
   set statistics xml off
   GO
   
   -- 동적 관리 개체에 포함된 xml 실행 계획 확인
   SELECT
       cp.refcounts,
       cp.usecounts,
    query_plan,
    text
   FROM  sys.dm_exec_cached_plans cp
   CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS p
   CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS q
   WHERE cp.cacheobjtype = 'Compiled Plan'
   GO