Home » RDBMS Server » Performance Tuning » use_hash hint without arguments (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)
use_hash hint without arguments [message #559404] Tue, 03 July 2012 03:19 Go to next message
manubatham20
Messages: 310
Registered: September 2010
Location: Noida, India
Senior Member
Hi,

Just want to know what if I have used /*+ USE_HASH */ only without providing any table name.

What will be the effect on tables that will be joined-

1. Will all the tables in query will be joined thorugh hash join?
2. Or optimizer will neglect that hint and proceed in its own way?

Thanks,
Manu

Report message to a moderator

Re: use_hash hint without arguments [message #559413 is a reply to message #559404] Tue, 03 July 2012 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 54719
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT use hint. full stop.

Regards
Michel

Report message to a moderator

Re: use_hash hint without arguments [message #559559 is a reply to message #559413] Wed, 04 July 2012 01:40 Go to previous messageGo to next message
Roachcoach
Messages: 1036
Registered: May 2010
Location: UK
Senior Member
Or at least, if you're asking questions about them Wink

Report message to a moderator

Re: use_hash hint without arguments [message #559561 is a reply to message #559559] Wed, 04 July 2012 01:52 Go to previous message
Michel Cadot
Messages: 54719
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This was implied. Wink

Report message to a moderator

Previous Topic: partition pruning
Next Topic: Investigating sudden Temp Tablespace growth from AWR?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 20 05:46:02 CDT 2013

Total time taken to generate the page: 0.20777 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.