Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Fw: analyze a partitioned table
>
>
> > Good morning everyone,
> >
> > Can anyone give me the command to analyze a partitioned tabled? To
> analyze
> > this table unpartitioned I use: analyze table schema.table_name compute
> > statistics;
> >
> > I am partitioning it into 6 partitions and want to compute statistics on
> > each partition.
> >
> > Thanks in advance,
> > Ruth
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jan 03 2002 - 08:04:03 CST