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

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
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: 65144
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).

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

Current Time: Sun Aug 20 10:40:08 CDT 2017

Total time taken to generate the page: 0.14055 seconds