This documentation is archived and is not being maintained.

Constant Scan Showplan Operator

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.

Constant scan operator icon Graphical execution plan icon