RE: HOW TO: fudge histogram information
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <breitliw@xxxxxxxxxxxxx>
- Date: Tue, 15 Feb 2005 13:57:36 +0100
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
Other related posts:
