Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to speed analyzing histograms

How to speed analyzing histograms

From: Kalle <kalle_at_nospam.com>
Date: Wed, 09 Nov 2005 06:06:03 GMT
Message-ID: <flgcf.14258$_k2.236505@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 
Received on Wed Nov 09 2005 - 00:06:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US