Table Scan Showplan Operator

The Table Scan operator retrieves all rows from the table specified in the Argument column of the query execution plan. If a WHERE:() predicate appears in the Argument column, only those rows that satisfy the predicate are returned.

Table Scan is a logical and physical operator.

Table scan operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Other Resources

SELECT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance