HASH_JOIN_ENABLED

Parameter type	Boolean
Default value	true
Parameter class	Dynamic: ALTER SESSION
Range of values	true | false

HASH_JOIN_ENABLED specifies whether the optimizer should consider using a hash join as a join method. If set to false, then hashing is not available as a join method. If set to true, then 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.