Re: ANALYZE vs. DBMS_STATS - do we need both?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Mar 2002 15:01:59 +0100
Message-ID: <3a5h9uoc184elc207rjp9qo66kuvk5q8ea@4ax.com>

On Wed, 20 Mar 2002 08:36:07 -0500, "Stephen B" <stephen.bell_at_cgi.ca> wrote:

>Hi to all,
>
>Is it accurate to say that DBMS_STATS gathers the same information for the
>optimizer as ANALYZE?
>
>In other words, would we want to use DBMS_STATS in addition to a policy of
>regularly analyzing database objects or is one of the two sufficient?
>
>Any insights are much appreciated.
>
>Thank you and best regards,
>
>Steve
>

dbms_stats has been designed to supplant analyze. Supposedly, according to Oracle, it is also more accurate. It also should allow you to analyze the objects with stale statistics only.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 20 2002 - 08:01:59 CST