Procedure documentationDisplaying Indexes Locate this document in the navigation structure

 

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

Prerequisites

Procedure

  1. In the explorer, expand the schema to which the indexes belongs.

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

  3. Specify the indexes to be displayed:

    Indexes: Display Criteria

    Option

    Description

    None

    All indexes from the selected schema are displayed.

    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 (Refresh).

Result

Indexes: Information (Selection)

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