Right Anti Semi Join Showplan Operator
TOC
Collapse the table of content
Expand the table of content

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.

Community Additions

ADD
Show:
© 2016 Microsoft