Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where can I get a complete list of all SQL Hints?

Re: Where can I get a complete list of all SQL Hints?

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Sat, 14 Jun 2003 22:45:41 +1000
Message-ID: <3eeb195c$0$16255$afc38c87@news.optusnet.com.au> 





"Geomancer" <pharfromhome_at_hotmail.com> wrote in message
news:cf90fb89.0306140419.322f281_at_posting.google.com...


> If the CBO is so great, why all the hints?




For the same reason SQL Server, Sybase


and DB2 have the same feature: the CBO is NOT
so great.



>

> Also, any ideas or tips for using the undocumented hints?




There was a thread a while ago about precisely that.
Do a check on google and you'll find it.


--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam


Received on Sat Jun 14 2003 - 07:45:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US