Home » SQL & PL/SQL » SQL & PL/SQL » Sql Hints
Sql Hints [message #258282] Fri, 10 August 2007 15:29 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

If the table does not contains statistics neither indexes. Is there anyway can i use any hint to increase the performance of the scripts which contains multiple Joins.
Re: Sql Hints [message #258294 is a reply to message #258282] Fri, 10 August 2007 18:11 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
You will give a hint when you know something about it. But if you don't anything about it giving a hint is useless as far as i know.
Re: Sql Hints [message #258319 is a reply to message #258282] Sat, 11 August 2007 00:30 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you use hint (almost all of them) Oracle switches to CBO and has you don't have statistics it takes default statistics.
So most of the cases you will go to suboptimal execution plan (unless you give full hints that lead to one and one plan, the one you want).

Regards
Michel
Previous Topic: Why package can't see v$session?
Next Topic: Materialised view and database view
Goto Forum:
  


Current Time: Fri Dec 09 17:29:32 CST 2016

Total time taken to generate the page: 0.42305 seconds