Re: DBMS_STATS compared to the analyze command: weird!

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Fri, 27 Feb 2004 00:27:05 +0100
Message-ID: <h20t30tq5qo48er6udf8gidj3sjr0l88h7@4ax.com>

"Syltrem" <syltremzulu_at_videotron.ca> wrote:

>Also note that you can save your old stats, with DBMS_STATS.
>So if something bad happens, you can retrieve them (very quickly) and you're
>back to your old stats and response time.
>
>I use this feature for one table where old stats make queries run faster,
>for some reason. I have a TAR open on this. Newly calculated stats on this
>particular table makes everything so much slower.
>
>If you can manage to restore your (old backup) db somewhere, save the stats,
>import them to your prod db, and re-apply them. That may or may not be
>quicker to doing the analyze again... you're the only one who can tell.

At times, Oracle performance tuning is like superstition...

I won't begin trying that kind of obscure things without exactly understanding why it works like it works. It could turn out as a huge waste of time too.

Bye
Rick Denoire Received on Thu Feb 26 2004 - 17:27:05 CST