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
always_anti_join
(which is
obsolete
).
_optimizer_extend_jppd_view_types
Index