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 next 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
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
akrish1982
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: Thu Mar 28 13:54:33 CDT 2024