Re: system statistics

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 10 Oct 2003 14:48:18 +0200
Message-ID: <bm69qk$n6f$1@news.fujitsu-siemens.com>

"Thomas Kyte" <thomas.kyte_at_oracle.com> schrieb im Newsbeitrag news:7b0834a8.0310091521.1f491ada_at_posting.google.com...
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<bm41va$278$1_at_news.fujitsu-siemens.com>...
> > "Thomas Kyte" <thomas.kyte_at_oracle.com> schrieb im Newsbeitrag news:7b0834a8.0310090722.7512c04_at_posting.google.com...
> > > What I was saying was that you might well discover you don't need to
> > > tweak them, if you have good system statistics.
> > So, what effect do they have in the presence of statistics?
>
> that is when they work "best"
>
> without valid object statistics -- the CBO doesn't stand a chance.

Ok, so I've got to play with the statistics AND the optimizer index parameters.

Lots of Greetings!
Volker Received on Fri Oct 10 2003 - 07:48:18 CDT