How Parallel Plans Start Up – Part 5
SQL Performance
MAY 17, 2021
Part 1 initialized execution context zero for the parent task, and part 2 created the query scan tree. Remember these numbers are being recorded against execution context zero — the Branch B parallel tasks do not exist yet. Adds a CXPipeMerge to merge rows from multiple pipes (since this is an order-preserving exchange).
Let's personalize your content