RE: clarification on partitioned tables

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 15 Jun 2006 13:24:51 -0500
Message-ID: <BAY107-F9C8A88C2C980B4705D49897820@phx.gbl>

Sorry.

Right now all that is being used is the analyze command on 9iRel2 Solaris 8.

I want to move to DBMS_STATS to collect stats on a partitioned table ( and the schema ) in 10gRel2 on Solaris 10.

thanks.

>Joe
>
> >I have a partitioned table in my schema. The cron job runs an analyze
> >command to collect statistics. Does the analyze command collect stats on
> >the table partitions? Do I have to explicitly use the:
> >
> >GRANULARITY => 'PARTITION'
> >
> >with dbms_stats to collect partition stats? I am reading Doc ID:
> >Note:237538.1
>
>Questions:
>- Do you use ANALYZE, DBMS_STATS or both? (In the first part of your
>description you wrote "analyze command".)
>- Which version of Oracle? (Different release, different behavior...)
>- Which are the other parameters you specify? (Some parameters are inferred
>from others...)
>
>
>Regards,
>Chris
>--
>http://www.freelists.org/webpage/oracle-l
>
>

---

Is your PC infected? Get a FREE online computer virus scan from McAfeeŽ Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 15 2006 - 13:24:51 CDT