Home » Applications » Other Application Suites » Why SAP recommends HASH_JOIN_ENABLED = FALSE (Oracle
Why SAP recommends HASH_JOIN_ENABLED = FALSE [message #311782] Sun, 06 April 2008 16:16 Go to next message
Messages: 621
Registered: July 2006
Senior Member

Anybody knows why SAP recommends to remove HASH join?

Note 124361 recommends setting hash_join_enabled = false

and I would like to know the reason for it, because in the system

uses SORT_MERGE join instead (and IMHO it's much worse).

icon12.gif  Re: Why SAP recommends HASH_JOIN_ENABLED = FALSE [message #386490 is a reply to message #311782] Sun, 15 February 2009 21:35 Go to previous message
Messages: 6
Registered: February 2009
Junior Member
just to let everyone know

this means that the optimizer does not use any hash joins when calculating the access plan.
Previous Topic: SAP related questions
Next Topic: oracle apps vs sap vs peoplesoft
Goto Forum:

Current Time: Sat May 18 07:38:51 CDT 2024