Search notes:

Oracle: Anti join

An anti join returns rows from the left table for which there are no corresponding rows in the right table.

See also

Unlike an anti join, a semi joins returns a record from the left table if there is a corresponding record in the right table.
Event 10102 switches off anti joins.
The init parameter

Index