Oracle Database Administration: The Essential Refe

The following is the syntax for the for_clause in the ANALYZE TABLE statement:

{
FOR TABLE |
FOR ALL [INDEXED] COLUMNS [SIZE integer] |
FOR COLUMNS column_name [SIZE integer] |
FOR ALL [LOCAL] INDEXES
}

FOR TABLE: Specifies that only the table is to be analyzed.
FOR ALL COLUMNS: Specifies that, instead of the table, all columns are to be analyzed; if you specify INDEXED, all indexed columns will be analyzed. SIZE specifies the number of buckets to be generated when columns are being analyzed.
FOR COLUMNS: Provides a list of columns to be analyzed.
FOR ALL INDEXES: Specifies that, instead of the table, all indexes are to be analyzed. This is equivalent to executing an ANALYZE INDEX command for all indexes. If you specify LOCAL, all local indexes will be analyzed.

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Oracle Database Administration: The Essential Refe by