Re: Strange results with Oracle 8.1.7 and statistic gathering dbms_stats vs dbms_utility

martin wrote:

> We have a customer with a large app using WebSphere and Oracle 8.1.7.
>
> They run:
>
> exec dbms_utility.analyze_schema('SAP', 'COMPUTE'); weekly.
>
> We recently ran:
>
> dbms_stats.gather_schema_stats(ownname=>'SAP';)
>
> on our test system and saw HUGE improvements in speed.
>
> Why is this? What is the difference between the two.
>
> Please help and advise.
>
> Martin Folb
> WGCUSA
Oracle only keeps the dbms_utility_analyze, and the other anlayze methods, around for purposes of backward compatibility. They are for all intents and purposes desupported and don't handle new features.

But I would suggest, in the future
dbms_stats.gatehr_schema_stats(ownname=>'SAP', cascade=TRUE)

so that it will also analyze the indexes.

Daniel Morgan Received on Thu Oct 03 2002 - 10:33:54 CDT