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

• ORCL

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:

1. Initiate an Analyze action against one or more clusters, indexes, primary keys, unique keys, or tables. For more information see Initiating an object operation.
2. 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.