title: MSSQL Null Query Plan
body: <p>I am executing below Query to get cached execution plan details. I am seeing that Query_Plan for some of the stored procedure is null . what could be the reason ? does it mean my query requires improvement ?</p>
  
  <pre><code>       SELECT plan_handle,usecounts, cacheobjtype, objtype, size_in_bytes, text,query_plan
           FROM sys.dm_exec_cached_plans 
    CROSS APPLY sys.dm_exec_sql_text(plan_handle)
    CROSS APPLY sys.dm_exec_query_plan(plan_handle)
          WHERE objtype = 'Proc' 
       ORDER BY usecounts DESC;
  </code></pre>