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

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

i promise not to do that anymore (and all future examples on the site will use dbms_stats as well).

I instituted that policy recently. it's a couple of extra keystrokes - but it can make a material difference in the statistic values, and just confused people.

> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:cie8nk$t7a_at_odah37.prod.google.com...
> > Howard J. Rogers wrote:
> > > Niall Litchfield wrote:
> > > >> Instead, they're saying if we don't use dbms_stats, we're going
> > > >> straight to hell.
> > > >
> > > > I'd like to see the reference.
> > >
> > > It *is* strongly recommended to stop using 'analyze table EMP'
> statements.
> > > And for the sort of good reasons I mentioned.
> >
> > What I was trying to get at was that I thought Domenic's question was
> > good because I have seen the advance warning that ANALYZE will be
> > removed at a later date, but I haven't seen much *from Oracle* saying
> > why. I agree with all your statements by the way - I should have
> > explained what I meant by flexible and didn't.
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.niall.litchfield.dial.pipex.com
> >
Received on Fri Sep 17 2004 - 14:33:31 CDT