Re: are hints still necessary in 9i?

From: Luc Gyselinck <Luc.Gyselinck_at_nospampandora.be>
Date: Wed, 08 Oct 2003 23:36:27 GMT
Message-ID: <%b1hb.66940$gm5.3414162@phobos.telenet-ops.be>

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.
Received on Wed Oct 08 2003 - 18:36:27 CDT