Re: Why prefer DBMS_Stats to Analyze?

Hi Max,

A few reasons I can think off the top of my head are:

1. DBMS_STATS can be performed in parallel
2. DBMS_STATS produces both global and partition statistics for partitioned objects
3. DBMS_STATS can use both block and row samples
4. Use DBMS_STATS so you're proficient before Oracle desupports Analyze ;)

Cheers

Richard

"M.a.x G.e.decke" wrote:
>
> Oracle says, that it is better to use the dbms_stats package than the
> analyze command. Does anybody know what the exact advantages are?
>
> thanx
>
> max
Received on Tue Aug 20 2002 - 03:01:24 CDT