How to speed analyzing histograms

Giganews Newsgroups
Subject: How to speed analyzing histograms
Posted by:  Kalle (kalle@nospam.com)
Date: Wed, 09 Nov 2005

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

Replies