Re: ANALYZE TABLE vs. dbms_stats

Ford Desperado wrote:

> is there any way to determine if the statistics were collected via
> ANALYZE TABLE or by the dbms_stats package? It's Oracle 9i
>
> TIA
Not as far as I know. But Oracle has advised, as of 9i, that ANALYZE TABLE no longer be used for creating optimizer statistics.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)