I just finished teaching the Oracle 10g New Features course. this is one of the many, many things you will learn about 10g in that course ... (sorry, I could not resist :-) Kind regards, Lex. > > Have I mentioned this before: > > It's a nice feature of 10g that whenever you update > the stats (legally), Oracle saves the prior values to > a history table; and there is a dbms_stats that allows > you do to things like: > put this table's stats back to 2:30 pm last Tuesday. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------