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 …