Show TOC

Displaying IndexesLocate this document in the navigation structure

Use

You display information about damaged, deactivated, and unused indexes.

Prerequisites
Procedure
  1. In the explorer, expand the schema to which the indexes belong.

  2. In the context menu of the Indexes folder, choose Show Indexes.

  3. Specify the indexes to be displayed:

    Table 1: Indexes: Display Criteria

    Option

    Description

    Only Bad Indexes

    Only damaged indexes are displayed.

    Only Disabled Indexes

    Only disabled indexes are displayed.

    Only Unused Indexes

    Only unused indexes are displayed ( INDEXUSED=0).

  4. Choose Refresh.

Result

Property

Description

Type

Indicates whether or not the index is Unique

Index Used

Indicates how often the system has used the index

Index Used Reset Time

Time when the counters for index use were reset

File State

Indicates whether the index is damaged

Disabled

Deactivated