Procedure
If indexes already exist on the table, a list of these indexes is displayed. Choose .
The maintenance screen for indexes appears.
You can then use the short text to find the index at a later time, for example with the R/3 Repository Information System.
The order of the fields in the index is very important. See
What to Keep in Mind for Secondary Indexes.A
unique index is always created in the database at activation because it also has a functional meaning (prevents double entries of the index fields).In this case you can use the radio buttons to define whether the index should be created for all database systems, for selected database systems or not at all in the database.
Click on the arrow behind the radio buttons. A dialog box appears in which you can define up to 4 database systems with the input help. Select Selection list if the index should only be created on the given database systems. Select Exclusion list if the index should not be created on the given database systems. Choose .
Result
The secondary index is automatically created in the database during activation if the corresponding table was already created there and index creation was not excluded for the database system.
You can find information about the activation flow in the activation log, which you can call with Utilities
® Activation log. If errors occurred when activating the index, the activation log is automatically displayed.See also:
Indexes