Re: Oracle statistics

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