Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: are hints still necessary in 9i?
Luc Gyselinck wrote:
>
> At every new release of Oracle, the CBO wil be enhanced, and thus
> (hopefully) make better desicions. But it will never be perfect. You will
> always encounter situations where you will need a hint.
>
> I hope, one day, the CBO will 'learn' from it's 'mistakes' it made when
> choosing the 'wrong' plan.
>
> "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
> news:1efdad5b.0310080503.12cd6fc8_at_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.
There are rumours of something akin to that in an upcoming release
hth
connor
Received on Thu Oct 09 2003 - 05:39:32 CDT