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

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 18 Sep 2004 10:55:31 +1000
Message-ID: <414b877e$0$20130$afc38c87@news.optusnet.com.au>

Thomas Kyte wrote:

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

Dang! That means I suppose I've got to behave now, too...

:-(
HJR Received on Fri Sep 17 2004 - 19:55:31 CDT