Synopsis

Values: NESTED_LOOPS, MERGE, or HASH

Default: NESTED_LOOPS

Sets the type of antijoin algorithm used by the Oracle Server. The system checks to verify that it is legal to perform an antijoin and, if it is, uses the value of this parameter to determine how it will process the subquery. When this parameter is set to the value NESTED_LOOPS, the Oracle Server evaluates the subquery using a nested loop antijoin algorithm. When it is set to the value MERGE, the Oracle Server uses the sort merge antijoin algorithm. When it is set to the value HASH, the Oracle Server uses the hash antijoin algorithm.