Index IDs
Several indexes on the same table are distinguished by a three-place index identifier. The index identifier may only contain letters and digits. The ID 0 is reserved for the primary index.
The index name on the database adheres to the convention <Table name>~<Index ID>.
TEST~A is the name of the corresponding database index in the database for table TEST and the secondary index with ID A.
Since the convention for defining the index name in the database has changed several times, some of the indexes in the database might not follow this convention.
Indexes created prior to Release 3.0 can have an 8-place name. The first 7 places (possibly filled with underlining) are for the table names, and the eighth place is for the (one-place) index identifier (for example TEST___A).
Indexes introduced with Release 3.0 can have a 13-place name in the database. The first 10 places (possibly filled with underlining) are for the table names, and the 11th to 13th places are for the three-place index identifier (for example TEST______A).