Re: Manipulate DATE histograms

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: makulev@xxxxxxx
  • Date: Sun, 10 Dec 2006 20:48:20 -0700

Have you looked at DBMS_STATS.PREPARE_COLUMN_VALUES and DBMS_STATS.SET_COLUMN_STATS ? 


At 01:59 PM 12/10/2006, Milen Kulev wrote:

Hi listers,
I am  looking for an example how to manipulate a histogram
On a DATE column with DBMS_STATS.
I  have only found examples using VARCHAR and NUMBER types.
Any pointers, links, articles, etc ?

Export/import  of the table + manipulating histogram is not an option,
Since the table is 20 GB and I have no (service) downtime window.

Many thanks in advance.

Best Regards.
Milen

--
//www.freelists.org/webpage/oracle-l


Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com 
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2006