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.

Graphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

SELECT (Transact-SQL)

Concepts

Logical and Physical Operators Reference

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)