Geek Answers Handbook

SQL Server Runtime Parallelism

I tried to optimize my query, and I came across a Parallelism show plan operator that I hadn't encountered before.

I wonder why this is and what indicates whether it is included in the implementation plan?

Thanks!

+7
source share
1 answer
Operator

A Parallelism in terms of SQL Server execution indicates that multiple threads will execute. For example, if the optimizer calculates that the operation would win and can be divided into several threads, it is distributed into several threads of execution, performs the task in separate threads, and then collects several threads back into the result set.

The Parallelism operator performs thread allocation, collects threads, and redistributes the logical operation flows.

If you haven’t seen it yet: Fundamentals of the implementation plan

Distribute streams execution plan icon Distribute thread execution plan icon

Gather streams execution plan icon Collect thread execution plan icon

Repartition streams execution plan icon Thread Redistribution Execution Plan Icon

+13
source

More articles:


All Articles