Creating an Index for Database Table TEMSGU 

Use

In large SAP systems with many users, there should be an index on field BDATE of table TEMSGU. This reduces the access time for the table.

Procedure

...

       1.      Start transaction SE11.

       2.      Enter TEMSGU in field Database Table and choose Change.

       3.      Choose Indexes.

       4.      Enter DAT in field Index name.

       5.      Enter Index of Read System Messages for a User in field Short description.

       6.      Select the options Non-unique index and Index on all database systems.

       7.      Enter BDATE in column Field name of table Index flds.

       8.      Choose Save and then Activate.