Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Partition Level Statistics gathering

PatzaNov 25 2008 — edited Nov 27 2008
Hi,

This is with regards to GRANULARITY option in DBMS_STATS.GATHER_TABLE_STATS procedure.

If I give 'PARTITION' as GRANULARITY would it gather statistics for all the partitions on a table or can I gather statistics only for a particular partition.

For example: If I have table T1 which is partitioned by month i.e JAN08, FEB08, ....., DEC09, JAN09, ... and If I apply DML only on say DEC08, can I gather statistics only for DEC08 partition ?

Please advise.

Thanks in Advance.

Regards
Pat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2008
Added on Nov 25 2008
9 comments
899 views