Distribute Streams Showplan Operator

The Distribute Streams operator is used only in parallel query plans. The Distribute Streams operator takes 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.

Distribute Streams is a logical operator.

Distribute streams parallelism operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

Gather Streams Showplan Operator
Parallelism Showplan Operator
Repartition Streams Showplan Operator

Concepts

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

Help and Information

Getting SQL Server 2005 Assistance