Press "Enter" to skip to content

Empty Parallel Zones in SQL Server

Paul White clues us in on an interesting phenomenon:

An empty parallel zone is an area of the plan bounded by exchanges (or the leaf level) containing no operators.

How and why does SQL Server sometimes generate a parallel plan with an empty parallel zone?

Read on for an example as well as the explanation.