Index for delete actions

When using delete actions in Dynamics AX, don’t forget that AX will have to look into database to know if there is any related record. And if there is no index, the performance can be really bad. I’ve just run into such a case, when deleting a customer executed a query running for six seconds. …

Continue reading ‘Index for delete actions’ »

Index fragmentation on xRef tables

Building cross-references for code in Dynamics AX creates millions of records in xRef tables. It has also very negative impact on fragmentation of database indexes. This is an example of indexes on xRefReferences table from a customer’s environment after rebuilding all cross references. And here the same set of indexes a few minutes later after …

Continue reading ‘Index fragmentation on xRef tables’ »

Included columns in Dynamics AX 2012

Included columns is a feature of SQL Server (since version 2005) related to indices.Thanks to it you can attach additional fields to an index that are not used for searching (so they don’t have to be maintained so expensively) but that can be used by database server to return data. If all columns being returned …

Continue reading ‘Included columns in Dynamics AX 2012’ »