Re: are hints still necessary in 9i?

Ryan Gaffuri wrote:

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

I've disagreed with Tom on many occassions. Unfortunately I've never been correct. ;-)

10g is, for me, far faster than 9.2.0.4 when installed on the same machine with the same data.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)