Skip to main content

Posts

Showing posts with the label Difference between Index and Index hint in Ax

Difference between Index and Index hint in MSD Ax

What is the difference between Index and Index hint? Index is used to give the control to the database for optimization. AX Kernel will add an OrderBy with all the fields of the index. Index Hint tells the database to use specified index and no other one. All Tables should have at least one find method that selects and returns one record method should be a Boolean variable called method; from the table that matches the unique index specified by the input parameters.