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: 566
Registered: September 2010
Location: Seattle, WA, USA
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
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT use hint. full stop.

Regards
Michel
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: 1576
Registered: May 2010
Location: UK
Senior Member
Or at least, if you're asking questions about them Wink
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This was implied. Wink

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


Current Time: Thu Mar 28 09:47:13 CDT 2024