Home » RDBMS Server » Performance Tuning » Usuage of hints.
Usuage of hints. [message #308694] Tue, 25 March 2008 04:06 Go to next message
vkrn
Messages: 18
Registered: March 2008
Junior Member
Hi all,
I have a query that chooses Hash join as join plan for its execution.But if i force the query to use nested loop join hint it is giving me less cost.Is it gud practise to use hints for the queries?

Thanks,
kiran.

Report message to a moderator

Re: Usuage of hints. [message #308695 is a reply to message #308694] Tue, 25 March 2008 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, let the optimizer chooses its path just give it correct statistics.

Regards
Michel

Report message to a moderator

Re: Usuage of hints. [message #308891 is a reply to message #308695] Tue, 25 March 2008 18:34 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Also the ultimate measure should be execution time and/or used resources not cost.

Gints Plivna

[Updated on: Wed, 26 March 2008 01:45] by Moderator

Report message to a moderator

Previous Topic: Oracle HASH GROUP BY & SORT GROUP BY performance
Next Topic: Partitioning effect
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 03:14:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.