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.
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, let the optimizer chooses its path just give it correct statistics.

Regards
Michel
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:
  


Current Time: Sat Dec 10 04:48:26 CST 2016

Total time taken to generate the page: 0.09142 seconds