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

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).

Michael
 
Read Message
Read Message icon12.gif
Previous Topic: SAP related questions
Next Topic: oracle apps vs sap vs peoplesoft
Goto Forum:
  


Current Time: Mon Feb 24 06:00:28 CST 2020