| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: truncate table vs. truncate table partition
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_at_verizon.net]
Sent: Thursday, 28 September, 2006 5:13 PM
To: joe_dba_at_hotmail.com
Cc: oracle-l_at_freelists.org
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 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 28 2006 - 10:24:24 CDT
 |
 |