yep -- you are right. see the "srec.bkvals" parameter. Forgot about that one; I was referring to the unsupported DIY technique :-) kind regards, Lex. --------------------------------------------- Visit my website at http://www.naturaljoin.nl --------------------------------------------- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfgang Breitling Sent: Tuesday, February 15, 2005 13:54 To: lex.de.haan@xxxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: HOW TO: fudge histogram information 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 -- //www.freelists.org/webpage/oracle-l