Re: Oracle 8i does NOT recommend using 'analyze table',is this true?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 27 Feb 2003 21:57:38 -0800
Message-ID: <3E5EFA52.686574A8@exesolutions.com>

Sybrand Bakker wrote:

> On 27 Feb 2003 20:24:26 -0800, mariocheung_at_msn.com (Mario Cheung)
> wrote:
>
> >And why ? thanks!
> because ANALYZE has been superseded by the dbms_stats package
> which
> - is capable of using multiple processors
> - generates more accurate statistics
> - has the option of working with various sets of statistics
> - can analyze tables which have stale statistics only
>
> regards
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

And another addendum ... DBMS_STATS handles partitions, index organized tables, and other new features that are not supported by the previous analyze methods.

Daniel Morgan Received on Thu Feb 27 2003 - 23:57:38 CST