Generating Application Indexes on CDB Tables 

Use

The middleware service generation you performed has created and changed queries on application tables. In order to improve the performance of these queries it is useful to create table indexes and to delete table indexes that are no longer required.

Prerequisites

You have made repository changes (new installation, upgrade, or changes).

Procedure

Perform the following steps:

In Test and Production Systems

...

       1.      In the menu choose Architecture and Technology ®Middleware ® Development ® Generation ® Generate Application Table Indexes.

The database is scanned for indexes. All indexes of tables that are recommended to be changed are therefore marked in the Index Selection List. If a table must be updated, all indexes of that table are displayed together with the action that should be performed and a description why a new index is needed.

       2.      To update all the indexes that are marked, click on Update Indexes.

All your table indexes are generated.

In Your Development System

In your development system, you can exclude table fields from being indexed before performing an index update.

...

       1.      In the Middleware menu, choose Development ® Generation ® Generate Application Table Indexes.

       2.      In the Index Selection List, unmark the index entries to exclude them from being updated. On choosing Update Indexes, the unmarked index field combinations are displayed in the Index Exception List. By marking them, they will be stored in the exception table TGN_INDEX_EXC. These exception table entries will be transported to your test and production systems. The entries of the exception table prevent the indexes from being displayed in the Index Selection List the next time. An index field combination will be displayed again in the Index Selection List if the entry is deleted from the exception table (using transaction code SM30).

       3.      Mark your exceptions in the Index Exception List and perform an index update.

To start the generation/deletion of indexes, click on Continue. To cancel the program, click on Cancel.

You can also create index entries manually by making an entry in the exception table TGN_INDEX_EXC. Use transaction code SM30 and enter your values. Choose a table key in the customer prefix namespace, Y and Z (X is reserved for customer generated entries, R is reserved for SAP generated entries). The index fields are separated by + signs.

Result

Table indexes are updated.

You can display the detailed result using transaction code SMOGLOG, which is also accessible as a pushbutton on the initial screen.

The updated indexes will not be transported. That means you should execute this tool on all CRM Servers in your system landscape.