Parameter Table Scan Showplan Operator

The Parameter Table Scan operator scans a table that is acting as a parameter in the current query. Typically, this is used for INSERT queries within a stored procedure.

Parameter Table Scan is a logical and physical operator.

Parameter 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)

Help and Information

Getting SQL Server 2005 Assistance