Right Outer Join Showplan Operator
The Right Outer Join operator returns each row that satisfies the join of the second (bottom) input with each matching row from the first (top) input. It also returns any rows from the second input that had no matching rows in the first input, joined with NULL. If no join predicate exists in the Argument column, each row is a matching row.
Right Outer Join is a logical operator.
See Also
Tasks
How to: Display an Actual Execution Plan
Concepts
Using Outer Joins
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)