Right Semi Join
Short Description
The Right Semi Join returns rows only from Table B only when there is a match Table A
Detailed Description​
The Right Semi Join returns rows from the second input only when there is a match in the first input. This is a mirror or the Left Semi Join.
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.