Re: Analyze vs dbms_stats

News wrote:
> Mladen Gogala a écrit :
>
> > DBMS_STATS also calls "ANALYZE", as described in the note mentioned above.
>
> I have traced DBMS_STATS. It generates select sum, count(*), min, max
> etc.. didn't see analyze command !!!

Did you trace what the Note said:

" o For example ,With 8.1.x DBMS_STATS uses recursive ANALYZE to gather statistics on

• All Index Statistics
• All Histograms

  o For example ,With 9.2.x DBMS_STATS uses recursive ANALYZE to gather statistics only on

• CLUSTER INDEX
• DOMAIN INDEX
• JOIN INDEX"

--
@home.com is bogus.
How do you drive a blogger crazy?  Put him in a round Starbucks and
tell him the wireless reception is in the corner.