Re: How to drop/delete/remove histograms? (CBO Column stats)

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Dec 2006 08:43:00 -0800
Message-ID: <1165423380.497790.56510@73g2000cwn.googlegroups.com>

On Dec 6, 6:05 am, eka_mercury-for..._at_yahoo.com wrote:
> Hello friends,
>
> Can anyone please tell me how to drop (only) histograms on a column?
>
> Ours is an OLTP application.
> Few of our queries go really bad when there are histograms.
> We need only NUM_DISTINCT, LOW_VALUE, HIGH_VALUE, DENSITY, NUM_NULLS,
> AVG_COL_LEN in the data dictionary.
>
> Or rather, how to retain only the above statistics and drop rest stats?
>
> The procedure DBMS_STATS.DELETE_COLUMN_STATS does not have any option
> to remove/add only selected statistics.
>
> - Manu

I know of no way to remove only the histograms. You will need to regenerate the statistics specifying "FOR ALL COLUMNS SIZE 1" to eliminate the histogram generation.

HTH -- Mark D Powell -- Received on Wed Dec 06 2006 - 10:43:00 CST