I have a partitioned table in my schema. The cron job runs an analyze
command to collect statistics. Does the analyze command collect stats on
the table partitions? Do I have to explicitly use the:


GRANULARITY => 'PARTITION'

with dbms_stats to collect partition stats? I am reading Doc ID:
Note:237538.1

any clarification or enlightment is appreciated.

thanks.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l