OraFAQ Forum: Other Application Suites » Why SAP recommends HASH_JOIN

Home » Applications » Other Application Suites » Why SAP recommends HASH_JOIN_ENABLED = FALSE (Oracle 9.2.0.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why SAP recommends HASH_JOIN_ENABLED = FALSE [message #311782]

Sun, 06 April 2008 16:16

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

[Message index]

		Why SAP recommends HASH_JOIN_ENABLED = FALSE By: michael_bialik on Sun, 06 April 2008 16:16
		Re: Why SAP recommends HASH_JOIN_ENABLED = FALSE By: akrish1982 on Sun, 15 February 2009 21:35

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 19:47:23 CDT 2024