Adding an Extension Index

To add further secondary indexes in other systems without making modifications, you can add them as extension indexes to a database table.

Procedure

  1. On the maintenance screen of the table, choose Indexes.

    If indexes already exist in the table, a list of these indexes is displayed.

  2. Choose .
  3. From the dropdown menu, choose Create Extension Index.

    A dialog box appears.

  4. In the new dialog box, enter the index ID and choose .

    The Maintenance screen for extension indexes appears.

  5. Enter an explanatory text in the field Short description.

    You can use the short description to find the extension index at a later time, for example via the Information System.

  6. To select the table fields to be inserted in the index, choose Table Fields.

    A list with all available fields appears.

  7. Select the desired fields using the indicator in the first column and then choose Copy.
  8. If the values in the index fields already uniquely identify each record of the table, select the Unique index radio button.

    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).

  9. If it is not a unique index, leave the Non-unique index radio button selected.
  10. In this case, you can use the radio buttons to define whether the index must be created for all database systems, for selected database systems, or not at all in the database.
    1. If the extension index must be created only for selected database systems, select For selected database systems.
    2. Choose .

      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.

    3. Choose  with the quick info text Continue.
  11. Choose .
  12. Choose .

Result

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 Start of the navigation pathUtilities Next navigation step Activation logEnd of the navigation path. If errors occur when activating the index, the activation log is automatically displayed.