Re: Performance decrease dramaticcaly by using statistics

From: Sharkie <sharkdba_at_yahoo.com>
Date: 26 Feb 2002 11:16:51 -0800
Message-ID: <423b5ab1.0202261116.502b76d0@posting.google.com>

"Gijanto, Ruud" <RGijanto_at_ctgzorg.nl> wrote in message news:<7C3B10C067C2D2119CE60020354473CE6806C7_at_SPICA>...
> OPTIMIZER_MODE = CHOOSE
> Without statistics is the elapsed time of a jobs/transactions
> approximately 1 minute.
> With statistics increase the elapsed-time to min. 25 minutes.
> I don't understand why this happened.

Not sure if this is your problem, but
it could be that you're analyzing objects owned by the SYS schema.

Don't do this, since these objects are already optimized, and analyzing them might decrease performance. Received on Tue Feb 26 2002 - 13:16:51 CST