Share via

Table Index Properties

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

In the Application Object Tree (AOT), the node for indexes is located at Data Dictionary > Tables > YourTable > Indexes. The following table describes the properties that are available for indexes on tables.



New in this version of
 Microsoft Dynamics AX


If set to Yes, the index can be non-unique.

If you do not create at least one unique index, Microsoft Dynamics AX creates one by combining the first index and the RecId.


Controls whether this index is part of an alternate key.

The index field must have a unique value in every record.

AX 2012


Sets the configuration key.

An index field that is disabled through a configuration key is automatically removed from the index.


Allows you to disable the index.


The internal identifier of the object.


Specifies which model the table index is in.

A model is a logical grouping of elements in a layer. An element can exist in exactly one model in a layer. Examples of elements are a table or class. The same element can exist in a customized version in a model in a higher layer.

AX 2012


Specifies the index name.


This property is for internal Microsoft use only.

Possible values are Yes or No. The default value is No.

The value of this UniqueAcrossCompanies property is ignored when the AllowDuplicates property is set to No. But when AllowDuplicates is Yes, a setting of UniqueAcrossCompanies to Yes can improve the performance of some cross-company queries. The performance improvement comes from changes to the caching of data.

AX 2012 R2


Specifies whether this index key is used to determine the valid time state relationship with the parent table. The default is No.


Requires setting AllowDuplicates to No and AlternateKey to Yes to enable the property.

AX 2012


Specifies whether gaps are allowed between two date effective records. The default is NoGap.


Requires setting AllowDuplicates to No, AlternateKey to Yes, and ValidTimeStateKey to Yes to enable the property.

AX 2012


Forms sort on the first index.

See also

Best Practices for Index Properties

How to: Create an Index

Best Practices for Indexes

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).