Home » RDBMS Server » Performance Tuning » optimizer ignoring USE_HASH hint in MERGE Query (10.2.0.3)
optimizer ignoring USE_HASH hint in MERGE Query [message #525194] Fri, 30 September 2011 01:43 Go to next message
deepa_balu
Messages: 74
Registered: March 2005
Member
Will optimizer ignore use_hash hint? while choosing join ordER?

[Updated on: Fri, 30 September 2011 04:15]

Report message to a moderator

Re: optimizer ignoring USE_HASH hint in MERGE Query [message #525251 is a reply to message #525194] Fri, 30 September 2011 06:35 Go to previous messageGo to next message
ejdrba
Messages: 27
Registered: May 2005
Location: Kolkata
Junior Member
You meant using ORDERED hints with USE_HASH, answer is no, it works.

Report message to a moderator

Re: optimizer ignoring USE_HASH hint in MERGE Query [message #525254 is a reply to message #525194] Fri, 30 September 2011 06:42 Go to previous message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't know how the optimizer works then don't use hints.

Regards
Michel

Report message to a moderator

Previous Topic: Virtual Columns : function based very slow
Next Topic: Views which will help in tuning SGA and PGA
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 14:03:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.