Re: DBMS_UTILITY.ANALYZE_SCHEMA vs. DBMS_STATS.GATHER_SCHEMA

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 09 Oct 2001 21:27:50 +0200
Message-ID: <lqj6stsdha58dcr26ca68ml0nikvq8d4sp@4ax.com>

On 9 Oct 2001 07:13:21 -0700, Finn_Nova_at_yahoo.de (Finn Nova) wrote:

>Hi,
>
>is there a difference between
>
>DBMS_UTILITY.ANALYZE_SCHEMA and DBMS_STATS.GATHER_SCHEMA_STATS ?
>
>Do I have to run both or only one?
>
>Thanx,
>
>Finn

dbms_utility.analyze_schema is equivalent with a series of analyze table commands

dbms_stat is the new method to gather statistics, which has superseded analyze table. Oracle claims it is faster, and provides better statistics.
Whatever you do, do not use both.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Oct 09 2001 - 14:27:50 CDT

Re: DBMS_UTILITY.ANALYZE_SCHEMA vs. DBMS_STATS.GATHER_SCHEMA_STATS