Index Analysis

Indexes are essential for fast efficient access to the data of the database instance. At regular intervals, check whether the indexes in the database system or SAP system are missing or bad. This is particularly important after major actions, such as an upgrade.

There are two types of inconsistency:

?     Indexes exist in the database instance, but are not defined in the ABAP Dictionary

?     Indexes exist in the ABAP Dictionary, but are not defined in the database instance

Procedure

You have the following options for the index analysis:

?     Displaying in the database assistant or the liveCache assistant: Indexes, Tables/Views/Synonyms
Bad indexes are always displayed in the
Properties user menu (OLTP/ liveCache).

?     Database Alert Monitor: Bad Indexes display or SAP consistency display
liveCache Alert Monitor: Bad Indexes display

?     Display DB filling/Tables and Indexes.

Result

Always recreate a missing index immediately, since it is very important for database system functions.

Indexes are used for special table scans and are important for performance.

You can use the database utility to recreate missing indexes (defined in the ABAP Dictionary, missing in the database instance).

See also:

Database – ABAP Dictionary Consistency

Database Manager GUI, Activating, Deactivating, or Deleting Indexes, Restoring Indexes After Database Restore