Analyze
Go Up to Available object actions by DBMS
This action lets you work with statistics for tables, indexes (primary keys and unique keys), and clusters.
Platform Availability
This action lets you build and submit the following ANALYZE statement variations or DBMS_STATS package procedure calls:
Options | ANALYZE statement variation or DBMS_STATS call generated |
---|---|
Compute Statistics |
ANALYZE INDEX/CLUSTER/TABLE... COMPUTE STATISTICS |
Gather Statistics |
DBMS_STATS.GATHER_INDEX_STATS DBMS_STATS.GATHER_TABLE_STATS, |
Delete Statistics |
ANALYZE INDEX/CLUSTER/TABLE... DELETE STATISTICS DBMS_STATS.DELETE_INDEX_STATS DBMS_STATS.DELETE_TABLE_STATS |
Estimate Statistics |
ANALYZE INDEX/TABLE/CLUSTER... ESTIMATE STATISTICS |
Validate Structure |
ANALYZE INDEX/TABLE/CLUSTER... VALIDATE STRUCTURE |
Import Statistics |
DBMS_STATS.IMPORT_INDEX_STATS DBMS_STATS.IMPORT_TABLE_STATS |
List Chained Row Into Table |
ANALYZE TABLE/CLUSTER... LIST CHAINED ROWS INTO |
- Note: Before using this object action, consult Oracle documentation for information on the ANALYZE statement and relevant DBMS_STATS package procedures. Be familiar with restrictions, required permissions, partition options, parameter values, and requirements. For more information, see Accessing Third Party Documentation.
To obtain or modify statistics for a database object:
- Initiate an Analyze action against one or more clusters, indexes, primary keys, unique keys, or tables. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in the Analyze wizard:
Step | Settings and tasks | |
---|---|---|
Action Options |
Take the following steps: | |
If you are not working against a cluster, either select the Use dbms_stats_package check box to generate one of the DBMS_STATS procedure calls or deselect the Use dbms_stats_package check box to generate an ANALYZE statement variation. | ||
From the Type dropdown, select one of the options from the table above. | ||
Additional options are offered depending on the Type value you choose. They correspond to ANALYZE statement clauses or DBMS_STATS procedure parameters. See Oracle documentation for details. | ||
Preview |
Displays the DDL that will execute the object action. For details, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.