RE: Manipulate DATE histograms
- From: "Milen Kulev" <makulev@xxxxxxx>
- To: <breitliw@xxxxxxxxxxxxx>
- Date: Thu, 14 Dec 2006 20:06:54 +0100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Wolfgang Breitling
Sent: Monday, December 11, 2006 4:48 AM
To: makulev@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
>
>--
>//www.freelists.org/webpage/oracle-l
Regards
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
