 |
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.
|