Re: Oracle statistics

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 12 Sep 2002 23:52:34 +1000
Message-ID: <cR0g9.30581$g9.87835@newsfeeds.bigpond.com>

Good morning Niall,

Hey, you watch my back and I'll watch yours ;)

Richard
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3d804f60$0$1285$cc9e4d1f_at_news.dial.pipex.com...
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:ZSWf9.30156$g9.86970_at_newsfeeds.bigpond.com...
> > 2) Look at using DBMS_STATS rather than analyze, pick an appropriate
sample
> > size (you haven't mentioned DB version but note 9i has some nice options
> > with this) and consider running in parallel, which is one of the
advantages
> > of this package.
>
> Oops I intended to mention this but seem to have got hung up on some other
> concern with the drop/recreate thingy :(. Good catch Richard.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
>
Received on Thu Sep 12 2002 - 08:52:34 CDT