December 2002
Intermediate to advanced
928 pages
85h 29m
English
ALWAYS_ANTI_JOIN
Value: NESTED_LOOPS | MERGE | HASH
Default: NESTED_LOOPS
Sets the type of antijoin that the Oracle Server uses. Obsolete with Oracle9i.
Server uses a nested loop antijoin algorithm.
Server uses the sort merge antijoin algorithm.
Server uses the hash antijoin algorithm to evaluate the subquery.