Distribute Streams

Distribute Streams

SQL Server 2000

Distribute Streams

The Distribute Streams logical operator is used only in parallel query plans. The Distribute Streams operator consumes a single input stream of records and produces multiple output streams. The record contents and format are not changed. Each record from the input stream appears in one of the output streams. This operator automatically preserves the relative order of the input records in the output streams. Usually, hashing is used to decide to which output stream a particular input record belongs.

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

See Also

Gather Streams

Parallel Query Processing


Repartition Streams

© 2015 Microsoft