必要になったので書くつもりが、良いの見つけたのでちょっとだけ改変。
元ネタ:Clustered Index Scan のプランを抽出する at SE の雑記
WITH XMLNAMESPACES ('http://schemas.microsoft.com/sqlserver/2004/07/showplan' AS sp) select * from ( SELECT RO.C.value(N'@LogicalOp','varchar(20)') as LogicalOp , text , query_plan , creation_time --, RO.C.value(N'@EstimateRows','numeric(20,5)') as EstimateRows , min_elapsed_time , max_elapsed_time , min_logical_reads , max_logical_reads , min_logical_writes , max_logical_writes , RO.C.value(N'(./sp:IndexScan/sp:Object/@Table)[1]', 'nvarchar(100)') as TableName FROM sys.dm_exec_query_stats CROSS APPLY sys.dm_exec_query_plan(plan_handle) CROSS APPLY sys.dm_exec_sql_text(sql_handle) CROSS APPLY query_plan.nodes(N'//sp:RelOp') as RO(C) WHERE RO.C.value(N'@LogicalOp','varchar(20)') like '%Index Scan' ) data_ where TableName = N'[テーブル名]'