Full Outer Join
Short Description
A Full Outer Join with return all rows (including unmatched rows) from both inputs and pass onto the next step
Detailed Description​
A Full Outer Join with return all rows from input A, and all rows from input B. This includes unmatched rows. Joined data will be passed on to the next step.
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.