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 -> are hints still necessary in 9i?

are hints still necessary in 9i?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 8 Oct 2003 06:03:13 -0700
Message-ID: <1efdad5b.0310080503.12cd6fc8@posting.google.com> 





Tom Kyte swears that if you properly analyze your table, the CBO is at
the point where you never need hints. I find I still need them
'occasionally', though not very often.



anyone else have opinions? anyone who beta tested 10g see an
improvement in the CBO? IT tends to get a little better with each
release.
Received on Wed Oct 08 2003 - 08:03:13 CDT












Original text of this message













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