Analyze Tables
Go Up to Available object actions by DBMS
This action lets you build and submit an ANALYZE TABLE statement, analyzing and storing the key distribution for a table.
Platform Availability
To analyze a table:
- Initiate an Analyze Tables action against one or more tables. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in this wizard:
| Step | Settings and tasks | |
|---|---|---|
|
Action Options |
Lets you review the tables you selected. | |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
|
Preview |
Displays the DDL that will execute the object action. For more information, see Preview. | |
- 3. Click Execute. For information on the scheduling option, see Scheduling.