Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_STATS vs. manual ANALYZE ... desupported?
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 Received on Thu Sep 16 2004 - 15:53:12 CDT