Re: DBMS_STATS vs. manual ANALYZE ... desupported?

Domenic wrote:

> Does anyone know *why* Oracle is saying we shouldn't do manual
> analyzing via our own scripts with or without dynamic PL/SQL loops?
>
> Instead, they're saying if we don't use dbms_stats, we're going
> straight to hell. I find using my own scripts allows me to create
> histograms where needed, to analyze more active tables and partitions
> more frequently, etc.
>
> Instead, in the 10g docs it says if we don't switch over to
> dbms_stats, the optimizer won't *see* our stats collected directly via
> ANALYZE in a future release.
>
> What does that mean? I thought dbms_stats just generated ANALYZEs in
> a loop behind the scenes. Am I missing something? I thought the end
> result was the same and that it could not be determined which method
> was used.
>
> Thanks in advance for all replies ...
>
> Domenic

For the same reason they have said stop using the RBO, stop using LONG, stop using LONG RAW, etc. Because it has been deprecated and all new functionality is being incorporated into DBMS_STATS. So, for example, if you are working with clusters, partitions, IOTs, etc. DBMS_UTILITY and its procedures are clueless.

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