Segment Repartition Showplan Operator

In a parallel query plan, sometimes there are conceptual regions of iterators. All of the iterators within such a region can be executed by parallel threads. The regions themselves must be executed serially.

Some of the Parallelism iterators within an individual region are called Branch Repartition. The Parallelism iterator at the boundary of two such regions is called Segment Repartition.

Branch Repartition and Segment Repartition are logical operators.

See Also


How to: Display an Actual Execution Plan


Parallelism Showplan Operator
Branch Repartition Showplan Operator
Segment Repartition Showplan Operator


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

Help and Information

Getting SQL Server 2005 Assistance