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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: SAP related questions
Next Topic: oracle apps vs sap vs peoplesoft
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 24 01:57:55 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.