Creating Models › Creating a Physical Model › Indexes › Inversion Entry Indexes

Inversion Entry Indexes

A non-unique, or inversion entry (IE), index is an index on a set of columns, other than the primary key column set, in a particular table. Duplicate values in the indexed columns are allowed.

In the logical model, you can create an Inversion Entry key group that uses one or more columns in a table and the corresponding non-unique index for the table is automatically created. In the physical model, you can use the Table Index Editor to create a non-unique index on a table. The default name for a non-unique index is XIEnTableName, as specified by the IndexName macro.