Re: truncate table vs. truncate table partition

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Thu, 28 Sep 2006 11:13:08 -0400
Message-id: <1159456388l.3261l.0l@medo.noip.com>

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

Received on Thu Sep 28 2006 - 10:13:08 CDT