Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Constant Scan operator introduces one or more constant rows into a query. A Compute Scalar operator is often used after a Constant Scan to add columns to a row produced by the Constant Scan operator.
For an example of the Constant Scan operator, see Interpreting Execution Plans of Partitioned Objects.
.gif "Constant scan operator icon")
Graphical execution plan icon
See Also
Tasks
How to: Display an Actual Execution Plan
Reference
Compute Scalar Showplan Operator
Concepts
Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)