Merge Join
Short Description
The Merge Join operator performs any of a number of join and union operations.
Detailed Description​
The Merge Join operator is used to performs join and union operations. This includes left joins, right joins, inner and outer joins. It is also used in union operations. The inputs are required to be sorted so there may be a sort operation preceding this, but are particularly efficient when taking input from an index.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.