Re: How to speed analyzing histograms

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Thu, 10 Nov 2005 00:26:39 +0100
Message-ID: <437285b0$0$10963$ba620e4c@news.skynet.be>

"Kalle" <kalle_at_nospam.com> wrote in message news:flgcf.14258$_k2.236505_at_news2.nokia.com...
> Hi all,
>
> we have 9.2.0.x database and we need to create histograms on weekly basis.
> The problem is that it takes a long time and we would like to speed it up.
> There are many tables with hundreds columns and hundred indexes
>
> Any ideas how to do this,
>
> Thank you in advance....
>
> Kalle

Use DBMS_STATS package and compute the statistics in parallel.

Matthias Received on Wed Nov 09 2005 - 17:26:39 CST