Checking for Missing Indexes 

Use

It is useful to compare the indexes that exist on the database with those that exist in the ABAP/4 Dictionary after an R/3 upgrade.

Due to the size of the tables in the SAP environment, tables need to be accessed via indexes to sustain an acceptable level of performance. If an index is missing or has been changed, it can have a negative effect on the performance of certain SAP reports.

Use the R/3 Static Database Monitor to find out whether any indexes that are defined in the ABAP/4 Dictionary do not exist in the database.

Procedure

  1. To start the R/3 Static Database Monitor, enter the transaction code DB02
  2. Choose the Database analysis button.

    3. A list of available database checks is displayed.

  3. To start the search for missing indexes, choose DB <-> ABAP/4 Dict. In the dialog box that appears choose Recheck.
  4. When the check has finished, the results are displayed on the screen.

Result

In the results screen, the first section shows the indexes which are declared in the SAP ABAP/4 Dictionary, but which do not exist in the database. The second section shows the indexes that exist in the database but are not declared in the SAP ABAP/4 Dictionary. Indexes that are declared in the SAP ABAP/4 Dictionary but do not exist in the database can be created as follows: Position the cursor on the index and click on the button Create in DB.

Always create a new index within the ABAP/4 Dictionary, otherwise errors will be generated during the missing indexes check.

See also:

R/3 Static Database Monitor