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