| # Indices (ttadv4521m000) Use this session to list, find or maintain the indices which are defined in a table. Table The code of the package for which the table is defined. Table The module code of the table. Table The identification code of the table, for which the index has been defined. A table is uniquely identified by this code in combination with the package and module codes. VRC The version of the package for which the table is defined. VRC The release of the package for which the table is defined. VRC The customer extension of the package for which the table is defined. Index Number The number of the index, which is a unique number within the table. Note The primary key always has index number 1. Dupl Yes Different records can have the same values in the index parts. These are called duplicate records. No Duplicate records are not allowed. The primary index (index number 1) may not have duplicates. For example : An item table has two indices :
Index no. | Part(s) | Duplicates
1 | Item code | no
2 | Item group | yes
Each record in the item table must have a unique item code. The combination of item group and description is not unique, so it is possible that two items in the item table have the same item group and description. Note: Indices allowing duplicate values can slow down delete actions on the table they refer to. You must make an index unique by adding the primary key at the end. Acti This field indicates whether the index is active or not. Note The primary index (index number 1) is always active. This information is not used in the data dictionary or the database layer. |