Re: are hints still necessary in 9i?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 08 Oct 2003 14:05:54 GMT
Message-ID: <6RUgb.141871$bo1.2028@news-server.bigpond.net.au>

"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.

Hi Ryan,

I don't like the term "never", never have ...

I much prefer your term "occasionally", which IMHO is close to the mark.

I might even be tempted to expand the term to "very occasionally" ;)

Cheers

Richard Received on Wed Oct 08 2003 - 09:05:54 CDT