Re: help:dbms_stats vs. analyze

a wrote:
>
> We have a scripts which will run every night to compare the num_rows in
> dba_table with the count(*) of the target tables, if not equal, we will
> analyze the table.
>
> Is there any advantage to switch to dbms_stats in terms of analyze results?
>
> Thanks for your help

You may want to check out ALTER TABLE .. MONITORING which will obviate the need for the "count(*)" to see if the table has changed.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."