Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Table Scan Showplan Operator
Collapse the table of content
Expand the table of content

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 icon Graphical execution plan icon

Community Additions

ADD
Show:
© 2015 Microsoft