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:
NTILE. Sequence Project will generate plans that have a Sequence Project and generally two segments.
Sequence Project is a physical and a logical operator.
Graphical execution plan icon
TasksHow to: Display an Actual Execution Plan
ConceptsLogical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)
Other ResourcesRANK (Transact-SQL)