RE: HOW TO: fudge histogram information

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 15 Feb 2005 13:57:36 +0100
Message-Id: <20050215125740.891CF975F8E@ha-smtp1.tiscali.nl>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
Sent: Tuesday, February 15, 2005 13:54
To: lex.de.haan_at_naturaljoin.nl
Cc: oracle-l_at_freelists.org
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

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



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

Received on Tue Feb 15 2005 - 08:00:31 CST