Name
ANALYZE TABLE
Synopsis
ANALYZE TABLE [schema.]table_name[PARTITION (partition_name) ] { COMPUTE STATISTICS [for_clause] | ESTIMATE STATISTICS [for_clause] [SAMPLEintegerROWS | PERCENT] | DELETE STATISTICS | VALIDATE STRUCTURE [CASCADE] | VALIDATE REF UPDATE | LIST CHAINED ROWS [INTO [schema.]table_name] }
Collects or deletes statistics about a table (table_name), validates the structure of the table, or identifies migrated and chained rows in the table.
Keywords
- PARTITION
Specifies one or more partitions to analyze in a partitioned index.
- COMPUTE STATISTICS
Computes the exact statistics for the entire named object and stores them in the data dictionary.
- ESTIMATE STATISTICS
Estimates statistics for the named object and stores them in the data dictionary. A SAMPLE may be specified: ROWS causes integer rows of a table or cluster, or integer entries from an index, to be sampled. PERCENT causes integer percent of the rows of a table or cluster, or integer percent of the entries of an index, to be sampled. The valid range for PERCENT is 1- 99.
- for_clause
Allows you to specify more granularity in the analyze. The syntax is shown in the later for_clause section.
- DELETE STATISTICS
Causes all statistics stored in the data dictionary for the named object to be deleted.
- VALIDATE STRUCTURE
Causes the structure of the named object to be validated. The CASCADE keyword causes any indexes associated with the named object also to be validated.
- VALIDATE REF UPDATE
Causes the object references to be validated and updated, if necessary.
- LIST CHAINED ROWS
Generates a list of chained and migrated rows for the named table or cluster (this operation is not permitted on an index). Entries are made in a table called CHAINED_ROWS that is assumed to exist in the user’s schema, unless the INTO clause specifies a differenttable_name.