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


Other related posts: