Show TOC

IndexesLocate this document in the navigation structure

Use

The Problem Analysis user menu contains many different options for analyzing indexes.

Procedure

  1. Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose Start of the navigation path Problem Analysis Next navigation step Indexes End of the navigation path.

    The display is part of the DBA Cockpit and can therefore also be called as follows:

    1. Open DBA Cockpit (transaction DBACOCKPIT).

    2. The display options in DBA Cockpit vary depending on which SAP NetWeaver release you are using.

      • Choose Start of the navigation path Diagnosis Next navigation step Database Objects Next navigation step Indexes End of the navigation path.

      • SAP NetWeaver 7.1: Choose Start of the navigation path Space Next navigation step  Indexes End of the navigation path.

  2. Enter the names of the schema, the tables and the index.

    When you specify the names, you can enter * as a wildcard (T0* for all table names that start with T0, for example).

    If you begin the name of a database object with an ", the subsequent letters are not changed into all caps, but instead are used for the query as you have entered them.

  3. Decide whether you want to filter the output:

    Only Display Bad Indexes

    Only Display Inaccessible Indexes

    Only Display Unused Indexes

    For information about the different filter options, see the online help for the SAP system.

  4. To display the list of indexes you want, select Adjust to Output Criteria.

Result

You can choose between the following analysis options:

  • More Information:

    You can display the Details for more information about tables and indexes.

    If you select a table, information is displayed to you (this display of information is described in Tables/Views/Synonyms).

    When you select an index, the CREATE INDEX statement that was used to generate the index is displayed.

  • Allow/Prevent Index Access:

    You can specify whether or not an index is used to access the data.

  • Reset Usage Counter:

    The database system records index usage in a counter. You can reset this usage counter.

  • Restore Index:

    You can restore defective indexes. Restoring an index may take a long time, depending on the size of the tables.

    You cannot access the tables related to an index while the index is being restored. It is therefore advisable to restore indexes at times when there is a reduced load on the system. You should restore indexes for larger tables in the background.

More Information