RE: HOW TO: fudge histogram information

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 15 Feb 2005 05:53:55 -0700
Message-Id: <6.2.0.14.2.20050215055218.02632270@pop.centrexcc.com>

At 05:37 AM 15/02/2005, Lex de Haan wrote:
>why don't you export the table data, update the column, gather statistics, and
>then import back the original data?
>otherwise, you have to update the dictionary. with a column population of two
>distinct values, you typicvally get two buckets with the cumulative
>cardinality
>-- so you only have to change one of the two endpoint_number values (which is
>unsupported, of course)

I hate to correct you, but it IS supported by means of the dbms_stats procedures prepare_column_values and set_column_stats.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 15 2005 - 07:56:44 CST