Get all SQL Statements with "table scan" in cached query plan

This Transact-SQL statements filters the cached query plans for existing table scan operators and returns the statement and query statistics. An additional filter is set on the attribute "EstimateRows * @AvgRowSize" = "Estimate size" to filter out scans on small tables.

 
 
 
 
 
4.1 Star
(15)
5,494 times
Add to favorites
Databases
8/23/2011
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


Be the first to ask a question.