Re: truncate table vs. truncate table partition
- From: Mladen Gogala <mgogala@xxxxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx
- Date: Thu, 28 Sep 2006 11:13:08 -0400
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
Other related posts:
