It doesn't help matters that Tom Kyte still uses ANALYZE in his Oracle
Magazine articles.
"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 - 07:04:57 CDT
