Re: are hints still necessary in 9i?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 09 Oct 2003 18:41:08 +0800
Message-ID: <3F853B44.16E1@yahoo.com>

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'm aligned sort-of with Tom, in that when I find an SQL that I can succesfully hint to run more efficiently, I use that as a catalyst to see where the cbo was "mis-informed". The CBO (like any mathematical function) is very prone to GIGO

hth
connor Received on Thu Oct 09 2003 - 05:41:08 CDT