Right Anti Semi Join Showplan Operator
The Right Anti Semi Join operator outputs each row from the second (bottom) input when a matching row in the first (top) input does not exist. A matching row is defined as a row that satisfies the predicate in the Argument column (if no predicate exists, each row is a matching row).
Right Anti 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)