Re: DBMS_STATS vs. manual ANALYZE ... desupported?

From: Thomas Kyte <thomas.kyte_at_oracle.com>
Date: 17 Sep 2004 17:38:19 -0700
Message-ID: <7b0834a8.0409171638.1ecdae70@posting.google.com>

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<414b2b9f$0$20248$cc9e4d1f_at_news-text.dial.pipex.com>...
> "Brian Dick" <bdick_at_cox.net> wrote in message
> news:XkA2d.37$Nq3.12_at_news-srv1.fmr.com...
> > It doesn't help matters that Tom Kyte still uses ANALYZE in his Oracle
> > Magazine articles.
>
> This surprises me somewhat. Do you have a reference?

I'm not sure if it ever made it into print in the magazine -- could be -- but I know I'm guilty of doing it with the Q&D (quick and dirty) examples on asktom in the past......

I shouldn't have (was just being lazy, for an example, "analyze table t" is less keystrokes).

so, i won't anymore. Received on Fri Sep 17 2004 - 19:38:19 CDT