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. Milen -- //www.freelists.org/webpage/oracle-l
-- Charles Schultz