Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Right Anti Semi Join Showplan Operator

SQL Server 2008 R2

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.

Community Additions

© 2016 Microsoft