Re: Manipulate DATE histograms

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Sun, 10 Dec 2006 20:48:20 -0700
Message-Id: <200612110351.kBB3pg8t001759@mail77.megamailservers.com>

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
>
>--
>http://www.freelists.org/webpage/oracle-l

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

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

Received on Sun Dec 10 2006 - 21:48:20 CST