Home » RDBMS Server » Performance Tuning » Usuage of hints.
Usuage of hints. [message #308694] Tue, 25 March 2008 04:06 Go to next message
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?

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

Re: Usuage of hints. [message #308891 is a reply to message #308695] Tue, 25 March 2008 18:34 Go to previous message
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: Thu Jul 27 02:09:09 CDT 2017

Total time taken to generate the page: 0.11249 seconds