Table Scan

From Optimizing SQL Database Performance

Optimizing Database Performance

Table Scan

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

See Also

SELECT