Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> clarification on partitioned tables
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 15 2006 - 11:34:19 CDT