Indexes

In the Problem Analysis user menu (OLTP/ liveCache) you can also find many different options for analyzing indexes.

Procedure

...

       1.      Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10).

       2.      Choose Problem Analysis ®Indexes.

       3.      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 following letters are not changed into a uppercase letters but rather are used for the query as you have entered them.

       4.      Decide whether you want to filter the output:
Display bad indexes only
Display inaccessible indexes only
Display unused indexes only

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

       5.      To display the list of indexes you want, select Ajust to output criteria.

Result

You can choose between the following analysis options:

?     More Information: You can look in 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).

If you select an index, you access the CREATE INDEX statement, which was used to generate the index.

?     Allow/prevent index access: you can specify whether or not an index is used for accessing the data.

?     Reset usage counter: the database system records usage of an index on a counter. You can reset the usage counter.

?     Restore index: you can restore a bad index. Restoring an index can take a long time, depending on the size of the tables. You cannot access the tables related to an index whilst the index is being restored. It is therefore advisable to restore indexes as times when there is little load on the system. You should restore indexes for larger tables in the background.

See also:

Database Management in the CCMS: MaxDB, Index Analysis, DB Filling/Tables and Indexes

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