If indexes already exist in the table, a list of these indexes is displayed.
A dialog box appears.
The maintenance screen for extension indexes appears.
You can use the short description to find the extension index at a later time, for example via the Information System.
A list with all available fields appears.
The order of the fields in the index is important.
The system always creates a unique index in the database at activation because it also has a functional meaning (prevents double entries of the index fields).
A dialog box appears in which you can define up to four database systems with the input help. Select Selection List if the index must be created only in the given database systems. Select Exclusion List if the index must not be created in the given database systems.
The secondary index is automatically created in the database during activation, if the corresponding table has already been created there and the index creation was not excluded for the database system.
You can find information about the activation flow in the activation log. To call the activation log choose Utilities → Activation log. If errors occur when activating the index, the activation log is automatically displayed.
See also: