Repartition Streams Showplan Operator

The Repartition Streams operator consumes multiple streams and produces multiple streams of records. The record contents and format are not changed. Each record from an input stream is placed into one output stream. If this operator is order preserving, all input streams must be ordered and merged into several ordered output streams.

If the output is partitioned, the Argument column contains a PARTITION COLUMNS:() predicate and the partitioning columns.

If the output is ordered, the Argument column contains an ORDER BY:() predicate and the columns being ordered.

Repartition Streams is a logical operator. The operator is used only in parallel query plans.

Repartition streams parallelism operator iconGraphical execution plan icon

See Also


How to: Display an Actual Execution Plan


Distribute Streams Showplan Operator
Gather Streams Showplan Operator


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

Help and Information

Getting SQL Server 2005 Assistance