Re: Table stats due to ANALYZE are removed

I don't think it's documented anywhere.
I came across this in 8.1.6, and it's
still true in 8.1.7.4, but 'fixed' in 9.2

Of course, since you have split a partition, you probably now have one partition with stats relating the original partition and one with stats that are null. So you need to re-analyse the two partitions anyway, at which point the table stats will accumulate from all the existing partitions and correct themselves 'spontaneously'.

Of course, Oracle has always said that
the table-level stats from ANALYZE are
not ideal anyway, because they use a
simple-minded accumulation of partition
stats, which could resulting completely
misleading figures.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 22nd
____Denmark__May 21-23rd
____USA_(FL)_May 2nd

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message
news:ieo79v8ucghig87oa40ogqvn9sc4pl30e9_at_4ax.com...


> I have done a lot of reading about ANALYZE vs DBMS_STATS but the

> urgency for using the package always escaped me, until I stumbled

upon


> the following (only tested in 8.0.5 and 8.1.7): if an ALTER TABLE

> SPLIT PARTITION is performed the *table* statistics gathered by an

> ANALYZE are removed, but if they are gathered by DBMS_STATS they are

> not.

>

> Is this documented anywhere? (bring in the URL's...)

>

> No wonder why Oracle added the package going from 8.0.5 to 8.1.7 and

> wants us to use it.

>

> Jaap.