RE: Manipulate DATE histograms

Hi Wolfgang ,
I have looked at DBMS_STATS.* functions and procedures. I have read your paper http://www.centrexcc.com/Using%20DBMS_STATS%20in%20Access%20Path%20Optimization.ppt.pdf (Page 30)too. What I need is an example how to format the dates to RAW format on order to initialize SREC.BKVALS array.

Best Regards. Milen

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling Sent: Monday, December 11, 2006 4:48 AM
To: makulev_at_gmx.net
Cc: oracle-l_at_freelists.org
Subject: Re: Manipulate DATE histograms

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

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