Analyzing all Indexes

About Analyzing all Indexes

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

 

Name Description

Index Name

The name of the index being analyzed.

Class DB Name

The DB Name of the class.

Property DB Name

The DB Name of the property.

Column Sequence

The column sequence in the index.

Sorting Order

The order in which the index data is stored.

Unique Rule

Indicates whether the index is unique.

Index Type

The type of index appears here.

Last Runstats Time

The time at which the index was last analyzed.

 

You can perform these tasks:

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

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

  • You can calculate the extended index statistics by selecting the Calculate extended Index Statistics check box.

  • After analyzing, click Reload Info to refresh.