Re: Index Compression question - solved, Thanks.

Jan Gelbrich wrote:

> Thanks Andy,
>
> Yes, we are using cbo, and that was why some tasks were much faster than
> others -
> I analyzed only a few tables and indexes after compressing, and only them
> were ok.
> All others were slower than before.
>
> I eventually analyzed one table with most complaints about it, and the
> problem was solved.
> I did not expect this to have *such* an effect, as the indexes were analyzed
> just some days before,
> and I thought that there cant be much difference in between time ... but
> actually it has.
>
> Thatīs a lession for the day ... always use dbms_utility.analyze_schema( )
> after compressing indexes.
>
> Thank You
> Jan
>
> <snipped>
> >

I believe Oracle's recommendation is to use DBMS_STATS. Analyze_schema is just there for backward compatibility.

Daniel Morgan Received on Fri Jan 17 2003 - 10:47:45 CST