-- Отсутствующие индексы, вызывающие издержки
SELECT TOP 100 
       [Total Cost] = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0),
       avg_user_impact,
       TableName = statement,
       [EqualityUsage] = equality_columns,
       [InequalityUsage] = inequality_columns,
       [Include Columns] = included_columns,
       [CreateTxt] = 'CREATE INDEX ' + QuoteName('IX_' + Object_Name(d.object_id,d.database_id) + '_' 
			+ Replace(Replace(Replace(isnull(equality_columns,''),'], [','_'),']',''),'[',''))
			+ ' ON ' + isnull(d.[statement],'') + ' (' + isnull(equality_columns,'') + ')'
			+ ' INCLUDE (' + isnull(d.included_columns,'') + ')'
  FROM sys.dm_db_missing_index_groups g 
	INNER JOIN sys.dm_db_missing_index_group_stats s ON s.group_handle = g.index_group_handle 
	INNER JOIN sys.dm_db_missing_index_details d ON d.index_handle = g.index_handle
  WHERE database_id = DB_ID()
  ORDER BY [Total Cost] DESC;

SELECT A.keyA
FROM A
WHERE Block=2 AND Status=3