PUSH_JOIN_PREDICATE
Values:TRUE or FALSE
Default:FALSE
Specifies whether push-join predicates will be enabled. This is a cost-based method of improving performance in certain queries by pushing individual join predicates into a view that is the right side of an outer join, thereby enabling a more efficient access path and join method. Examples are hash joins transforming into nested loop joins or full table scans becoming index scans.