-- Query to identify the missing indexes in t-sql of sql server -- from the dynamic views BEGIN -- Do not lock anything, and do not get held up by any locks. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT TOP 20 st.text AS [SQL] , cp.cacheobjtype , cp.objtype , DB_NAME(st.dbid)AS [DatabaseName] , cp.usecounts AS [Plan usage] , qp.query_plan FROM sys.dm_exec_cached_plans cp CROSS APPLY sys.dm_exec_sql_text(cp.pla... st CROSS APPLY sys.dm_exec_query_plan(cp.p... qp WHERE CAST(qp.query_plan...