캐싱된 plain 에서 Missing index 쿼리 확인

with XMLNAMESPACES ('http://schemas.microsoft.com/sqlserver/2004/07/showplan' as sql)
SELECT --TOP 10
    db_name
    ,sp_name
    ,sp_text
    ,[statement_text]
    ,X.*
    ,[creation_time]
    ,[ExecutionCount]
FROM
(
    SELECT
        db_name(qt.dbid) AS 'db_name'
        ,qt.text AS 'sp_text'
        , substring(qt.text, (qs.statement_start_offset/2)+1
                  , ((case qs.statement_end_offset
                  when -1 then datalength(qt.text)
                  else qs.statement_end_offset
                  end - qs.statement_start_offset)/2) + 1) as statement_text
        , qs.creation_time
        , qs.execution_count AS 'ExecutionCount'
        , cast(qp.query_plan as xml) as query_plan
        ,OBJECT_NAME(qp.objectid,qp.dbid) as sp_name
    FROM sys.dm_exec_query_stats AS qs
        CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
        CROSS APPLY sys.dm_exec_text_query_plan(qs.plan_handle,qs.statement_start_offset,qs.statement_end_offset) qp
) Y
CROSS APPLY
(
    SELECT
        c.value('(./@Impact)[1]','float') as missing_index_Impact
        ,c.value('(./sql:MissingIndex/@Database)[1]','varchar(100)') + '.'+
        c.value('(./sql:MissingIndex/@Schema)[1]','varchar(100)') + '.'+
        c.value('(./sql:MissingIndex/@Table)[1]','varchar(100)') as [missing_index_Table]
    FROM Y.query_plan.nodes('//sql:MissingIndexGroup')B(C)
) X