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 - 03:54:12 CDT
