Re: Manipulate DATE histograms

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: makulev@xxxxxxx
  • Date: Sun, 10 Dec 2006 20:27:57 -0600

How many distinct dates do you have? And what are you hoping to accomplish?
From a rudimentary point of view, I do not see why the datatype would make
much of a difference in this case.

On 12/10/06, Milen Kulev <makulev@xxxxxxx> 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.


Charles Schultz

Other related posts: