Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Dec 14 2006 - 13:06:54 CST
![]() |
![]() |