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
--
http://www.freelists.org/webpage/oracle-l
Regards
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: Manipulate DATE histograms
- From: Milen Kulev
- References:
- Manipulate DATE histograms
- From: Milen Kulev
Other related posts:
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
- RE: Manipulate DATE histograms
- From: Milen Kulev
- Manipulate DATE histograms
- From: Milen Kulev