Re: HOW TO: fudge histogram information

Have a look at dbms_stats.prepare_column_values followed by dbms_stats.set_column_stats.

At 05:30 AM 2/15/2005, Leonard, George wrote:
>Hi all
>
>I need to change oracle idea of what the data looks like in a column
>that is indexes. Currently when the column is analyzed there are 2
>values with a 50/50 split. (STATUS=OPEN or CLOSE)
>
>I need to lie to it so that it thinks there are less than 5% open
>compared to closed so that it accesses the data via the index and not a
>table scan.
>
>
>George
> ________________________________________________

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

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