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_at_gmx.net> 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
>
>
>
--
Charles Schultz
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Dec 10 2006 - 20:27:57 CST
