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. If the query optimizer uses a bitmap filter, the number of rows in the output stream is reduced. 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