See http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem8a.htm#2058616 "PARTITION | SUBPARTITION
Specify the partition or subpartition on which you want statistics to be gathered. You cannot use this clause when analyzing clusters. If you specify PARTITION and table is composite-partitioned, Oracle analyzes all the subpartitions within the specified partition. " command should be something like: analyze table schema.table_name partition (p1) compute statistics; -Joe At 05:00 AM 1/3/02 -0800, you wrote: >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
