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

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 18 Sep 2004 07:03:35 +1000
Message-ID: <414b5121$0$20127$afc38c87@news.optusnet.com.au>

Brian Dick wrote:

> It doesn't help matters that Tom Kyte still uses ANALYZE in his Oracle > Magazine articles.

Don't we all? (Rhetorical question!)

I know I still do, because it's a bit quicker to type, it's hardwired in the brain, the syntax is easier, and I'm a curmudgeonly old timer anyway.

It takes up less room on the page, too.

And, not least, analyze works for every version since at least 7. Analyze commands only kicked in with 8.0 (I think... maybe 8i), and underwent some significant enhancements in 9i. So if I'm writing a generic paper, I like to keep things version-agnostic.

I expect Tom did/does similarly.

Regards
HJR

> 
> "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 - 16:03:35 CDT