RE: clarification on partitioned tables

Joe

>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

Questions:

- Do you use ANALYZE, DBMS_STATS or both? (In the first part of your description you wrote "analyze command".)
- Which version of Oracle? (Different release, different behavior...)
- Which are the other parameters you specify? (Some parameters are inferred from others...)

Regards,
Chris

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