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.
Property |
Description |
New in this version of |
|---|---|---|
AllowDuplicates |
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. |
|
AlternateKey |
Controls whether this index is part of an alternate key. The index field must have a unique value in every record. |
AX 2012 |
ConfigurationKey |
Sets the configuration key. An index field that is disabled through a configuration key is automatically removed from the index. |
|
Enabled |
Allows you to disable the index. |
|
ID |
The internal identifier of the object. |
|
Model |
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 |
Name |
Specifies the index name. |
|
UniqueAcrossCompanies |
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 |
ValidTimeStateKey |
Specifies whether this index key is used to determine the valid time state relationship with the parent table. The default is No. Tip Requires setting AllowDuplicates to No and AlternateKey to Yes to enable the property. |
AX 2012 |
ValidTimeStateMode |
Specifies whether gaps are allowed between two date effective records. The default is NoGap. Tip Requires setting AllowDuplicates to No, AlternateKey to Yes, and ValidTimeStateKey to Yes to enable the property. |
AX 2012 |
Note
Forms sort on the first index.
See also
Best Practices for Index Properties
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).