Name
ANALYZE
Synopsis
ANALYZE {TABLE [schema.]table_name
[PARTITION partition_name | SUBPARTITION subpartition_name]
| INDEX [schema.]indexname
[PARTITION partition_name | SUBPARTITION subpartition_name]
| CLUSTER [schema.]clustername}
}
{ COMPUTE [SYSTEM] STATISTICS
| ESTIMATE [SYSTEM] STATISTICS [SAMPLE integer {ROWS | PERCENT}]
{[FOR {TABLE
| ALL [INDEXED] COLUMNS [SIZE integer]
| COLUMNS [SIZE integer] {column_name | attribute} [SIZE integer]
| ALL [LOCAL] INDEXES]
}
}
| DELETE [SYSTEM] STATISTICS
| VALIDATE STRUCTURE [CASCADE]
| LIST CHAINED ROWS [INTO [schema.]table_name]
| VALIDATE REF UPDATE [SET DANGLING TO NULL]
}Collects or deletes statistics about an object in the database, validates the structure of an object, or identifies migrated and chained rows in a table or cluster.
Statistics are accessible in the ALL_TABLES, USER_TABLES, and DBA_TABLES views. Some column statistics are accessible in the ALL_TAB_COLUMNS, USER_TAB_COLUMNS, and DBA_TAB_COLUMNS views. Cluster statistics also appear in USER_CLUSTERS and DBA_CLUSTERS.
Keywords
- 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. The optional SAMPLE clause may be used to specify the sample size to use; this clause contains the following keywords:
- ROWS
Causes integer rows of a table or cluster, or integer entries from an index, to be sampled.
- PERCENT
Causes integer ...