Repartition Streams

Optimizing SQL Database Performance

Optimizing Database Performance

Repartition Streams

The Repartition Streams logical operator is used only in parallel query plans. 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, then all input streams must be ordered and merged into several ordered output streams.

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

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

See Also

Distribute Streams

Parallel Query Processing

Gather Streams