SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Database Engine

Accessing and Changing Database Data

Query Performance

Query Tuning

Analyzing a Query

Logical and Physical Operators Reference

Aggregate Showplan Operator

Arithmetic Expression Showplan Operator

Assert Showplan Operator

Assign Showplan Operator

Async Concat Showplan Operator

Bitmap Showplan Operator

Bitmap Create Showplan Operator

Bookmark Lookup Showplan Operator

Branch Repartition Showplan Operator

Broadcast Showplan Operator

Cache Showplan Operator

Clustered Index Delete Showplan Operator

Clustered Index Insert Showplan Operator

Clustered Index Scan Showplan Operator

Clustered Index Seek Showplan Operator

Clustered Index Update Showplan Operator

Collapse Showplan Operator

Compute Scalar Showplan Operator

Concatenation Showplan Operator

Constant Scan Showplan Operator

Convert Showplan Operator

Cross Join Showplan Operator

Cursor Catchall Showplan Operator

Declare Showplan Operator

Delete Showplan Operator

Deleted Scan Showplan Operator

Distinct Showplan Operator

Distinct Sort Showplan Operator

Distribute Streams Showplan Operator

Dynamic Showplan Operator

Eager Spool Showplan Operator

Fetch Query Showplan Operator

Filter Showplan Operator

Flow Distinct Showplan Operator

Full Outer Join Showplan Operator

Gather Streams Showplan Operator

Hash Match Showplan Operator

Hash Match Root Showplan Operator

Hash Match Team Showplan Operator

If Showplan Operator

Inner Join Showplan Operator

Insert Showplan Operator

Inserted Scan Showplan Operator

Intrinsic Showplan Operator

Iterator Catchall Showplan Operator

Key Lookup Showplan Operator

Keyset Showplan Operator

Language Element Catchall Showplan Operator

Lazy Spool Showplan Operator

Left Anti Semi Join Showplan Operator

Left Outer Join Showplan Operator

Left Semi Join Showplan Operator

Log Row Scan Showplan Operator

Merge Interval Showplan Operator

Merge Join Showplan Operator

Nested Loops Showplan Operator

Nonclustered Index Delete Showplan Operator

Nonclustered Index Insert Showplan Operator

Nonclustered Index Scan Showplan Operator

Nonclustered Index Seek Showplan Operator

Nonclustered Index Spool Showplan Operator

Nonclustered Index Update Showplan Operator

Online Index Insert Showplan Operator

Parallelism Showplan Operator

Parameter Table Scan Showplan Operator

Partial Aggregate Showplan Operator

Population Query Showplan Operator

Refresh Query Showplan Operator

Remote Delete Showplan Operator

Remote Insert Showplan Operator

Remote Query Showplan Operator

Remote Scan Showplan Operator

Remote Update Showplan Operator

Repartition Streams Showplan Operator

Result Showplan Operator

RID Lookup Showplan Operator

Right Anti Semi Join Showplan Operator

Right Outer Join Showplan Operator

Right Semi Join Showplan Operator

Row Count Spool Showplan Operator

Segment Showplan Operator

Segment Repartition Showplan Operator

Sequence Showplan Operator

Sequence Project Showplan Operator

Snapshot Showplan Operator

Sort Showplan Operator

Split Showplan Operator

Spool Showplan Operator

Stream Aggregate Showplan Operator

Switch Showplan Operator

Table Delete Showplan Operator

Table Insert Showplan Operator

Table Scan Showplan Operator

Table Spool Showplan Operator

Table Update Showplan Operator

Table-valued Function Showplan Operator

Top Showplan Operator

Top N Sort Showplan Operator

UDX Showplan Operator

Union Showplan Operator

Update Showplan Operator

While Showplan Operator

Cursor Logical and Physical Showplan Operators

Minimize

This topic has not yet been rated - Rate this topic

Sequence Project Showplan Operator

SQL Server 2005

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 icon Graphical execution plan icon

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)

Other Resources

RANK (Transact-SQL)
DENSE_RANK (Transact-SQL)
ROW_NUMBER (Transact-SQL)
NTILE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.