Encontrar Falta de Indices e Conversão Implicita

indiceseconversao.sql

SET TRANSACTION isolation level READ uncommitted

SELECT TOP 20 ST.text          AS [PARENT QUERY], 
             Db_name(ST.dbid) AS [ DATABASENAME ], 
             CP.usecounts     AS [USAGE COUNT], 
             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 
WHERE  Cast(QP.query_plan AS NVARCHAR(max)) LIKE '%<MissingIndexes>%' or
		Cast(QP.query_plan AS NVARCHAR(max)) LIKE '%CONVERT_IMPLICIT%'
		AND db_name(st.dbid) = 'Piloto'
ORDER  BY CP.usecounts DESC