Gather Streams Showplan Operator

The Gather Streams operator is only used in parallel query plans. The Gather Streams operator consumes several input streams and produces a single output stream of records by combining the input streams. The record contents and format are not changed. If this operator is order preserving, all input streams must be ordered.

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

Gather Streams is a logical operator.

Gather streams parallelism operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

Distribute 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