Initialization Parameters, 57 of 188

HASH_JOIN_ENABLED

Parameter type:	Boolean
Parameter class:	Dynamic. Scope= `ALTER` `SESSION.`
Default value:	`TRUE`
Range of values:	`TRUE` \| `FALSE`
`HASH_JOIN_ENABLED` specifies whether the optimizer should consider using a hash join as a join method. When set to `FALSE`, hashing is not available as a join method. When set to `TRUE`, the optimizer compares the cost of a hash join with other types of joins, and chooses hashing if it gives the best cost. Oracle Corporation recommends that you set this parameter to `TRUE` for all data warehousing applications.