Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Analyze all indexed columns
Iain,
This is covered in greater detail in the SQL Reference manual under the Analyze command, but here's a summary of the basics.
Computing/estimating statistics on the table (without a FOR clause) calculates/estimates stats for the table and its indexes.
The for clause has the following options: For Table - table stats only
For Columns <column_list>
All Columns
For All Indexed Columns - gathers column stats on
the specified columns, all columns, or only the
indexed columns. If the SIZE option is also included,
then histogram information is gathered as well.
For more details on histograms see metalink note 1031826.6 "Histograms: An Overview"
Some key details to consider before using histograms:
HTH,
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: abardeen1_at_yahoo.com 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 Mon Sep 03 2001 - 08:00:15 CDT
![]() |
![]() |