granularity, values are : DEFAULT Gather global- and partition-level statistics PARTITION Gather partition-level statistics. SUBPARTITION Gather subpartition-level statistics. GLOBAL Gather global statistics (default) * ALL Gather all (subpartition, partition, and global) statistics Checking statstics, gathering statistics on partitioned tables, partitons, subpartitions, so easy and fast :p http://www.smenu.org/shct/smenu_gather_stat_tbl_ksh.txt Regards B. Polarski -----Original Message----- From: Mladen Gogala [mailto:mgogala@xxxxxxxxxxx] Sent: Thursday, 28 September, 2006 5:13 PM To: joe_dba@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: truncate table vs. truncate table partition On 09/28/2006 11:04:35 AM, Joe Smith wrote: > Explain this to me: > > this is a partitioned table with global indexes. > > sql>analyze table joe.catalog compute statistics for all indexes; > Joe, look in the Metalink for the article that explains the difference between analyze and DBMS_STATS. Analyze command does not descend into partitions. That is why DBMS_STATS has a "granularity" argument. -- Mladen Gogala http://www.mladen-gogala.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l