Sequence Project Showplan Operator

The Sequence Project operator adds columns to perform computations over an ordered set. It divides the input set into segments based on the value of one or more columns. The operator then outputs one segment at a time. These columns are shown as arguments in the Sequence Project operator.

Microsoft SQL Server supports four types of functions: RANK, DENSE_RANK, ROW_NUMBER, and NTILE. Sequence Project will generate plans that have a Sequence Project and generally two segments.

Sequence Project is a physical and a logical operator.

Sequence project operator iconGraphical execution plan icon

See Also


How to: Display an Actual Execution Plan


Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Other Resources

RANK (Transact-SQL)
NTILE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance