How to: Create an Index [AX 2012]
Updated: February 8, 2012
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
A table index is a database object that you can create in the Application Object Tree (AOT) to optimize access to table records.
Note |
|---|
|
It is recommended that you define only as many indexes as you need for optimum database performance. |
To specify an index in a select statement, use the index keyword. For more information, see Select Statement Syntax.
To manage changes to AOT objects, a version control system is available. For more information, see Version Control System.
-
In the AOT, locate the table that you want to add an index to, right-click the Indexes node, and then click New Index.
-
Right-click the new index, and then click New Field.
-
Right-click the field you added in step 3, click Properties, and then select a field from the DataField property list.
Repeat steps 2 - 3 to add more fields to the index.
The order of the fields determines the sorting order of the records. If a sorting conflict occurs, the data is sorted on the next field.
Note Any field of type String is transformed into lowercase.
-
Right-click the new index, and then click Properties.
-
Specify whether the index is unique or non-unique by doing one of the following:
-
To specify that the index is a non-unique index, confirm that the AllowDuplicates property is set to Yes. It is recommended that you create non-unique indexes for optimum database performance.
Note If you include a RecId field in an index, the index will be unique. When you include this field and set the property to Yes, the Microsoft Dynamics AX compiler displays a warning.
-
To specify that the index is unique, set the AllowDuplicates property to No. When the index is unique, you cannot insert records with duplicate key values. A warning is issued to the user if he attempts to insert records with duplicate values.
-
-
To disable the index, set the Enabled property to No. When you disable an index, it is deleted from the database.
You can also delete an index by right-clicking the index, and then clicking Delete.
-
Modify additional properties as needed.
Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.