Analyzing all Classes

About Analyzing All Classes

This option allows you to analyze only the classes in the CISDBA schema. When you click Classes tab in the Update Statistics window, the Update Statistics - Classes window appears.

 

Name Description

Class Label

The label of the Class being analyzed.

Class DB Name

The DB Name of the Class being analyzed.

Last Runstats Time

The time at which the class was last analyzed.

 

You can perform these tasks:

  • Click the top left row header button. All the classes will be highlighted. Click Analyze to analyze all the classes in the CISDBA schema.

  • To analyze a specific class or classes, click the row headers for the corresponding classes to be analyzed and click Analyze.

  • You can include indexes for the selected classes and calculate the extended index statistics by checking the appropriate check boxes.

  • After analyzing, click Reload Info to refresh.