Index naming convention

LN indexes are identified by a sequence number for each table, with the sequence numbers beginning with one. Each table has at least one index: the primary index. For each user, Oracle requires that all index names be unique; therefore, the table name and the index number are included in the index name.

Index names have this format:

t<DD Table Name><Company Number>$idx<Index Number>

For example, the index name for an LN table with name ttadv999, index number 1, company number 000 is tttadv999000$idx1.

If an LN index is defined as a unique index, the Oracle index is created with the UNIQUE clause. Without the UNIQUE clause, duplicate indexes are created.

The Oracle driver uses the index name conventions to create and delete indexes. Index names allow you to generate index hints to help the Oracle cost-based optimizer (CBO) to choose the appropriate execution plan.

Note:

Secondary tables, which are used by the Document Authorization feature, have the same indexes as the primary tables, but the index names have this format:
```
v<DD Table Name><Company Number>$idx<Index Number>
```
When the Multilanguage Application Data feature is enabled for a table or a table has BLOB columns, the following additional index is created:
```
[s|t]<DD Table Name><Company Number>$UUID
```