ANALYZE
ANALYZE {TABLE [schema.]tablename |
         INDEX [schema.]indexname
						|
         CLUSTER [schema.]clustername
        }
       {COMPUTE STATISTICS |
        ESTIMATE [SAMPLE integer {ROWS | PERCENT}] STATISTICS
        DELETE STATISTICS

        VALIDATE STRUCTURE [CASCADE]


        LIST CHAINED ROWS [INTO [schema.]tablename]

       }

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.

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. The SAMPLE 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 percent of the rows of a table or cluster, or integer percent of the entries in an index, to be sampled. The valid range for PERCENT is 1-99. If SAMPLE is not specified, a default value of 1050 rows will be used as the sample size.

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 will also cause indexes associated with the named object to be validated.

LIST CHAINED ROWS

Generates a list of chained and migrated rows for the named table ...

Get Oracle SQL: the Essential Reference 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.