Right Semi Join Showplan Operator
The Right Semi Join operator returns each row from the second (bottom) input when there is a matching row in the first (top) input. If no join predicate exists in the Argument column, each row is a matching row.
Right Semi Join is a logical operator.
See Also
Tasks
How to: Display an Actual Execution Plan
Concepts
Using Joins
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)