RE: HOW TO: fudge histogram information
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: lex.de.haan@xxxxxxxxxxxxxx
- Date: Tue, 15 Feb 2005 05:53:55 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
