Purpose: The purpose of this blog post is to document how can we rebuild or reorganize table indexes to improve performance of Dynamics AX 2012. Product: Dynamics AX 2012 Solution: The following script gives us index fragmentation details. Use <databasename> select s.database_id, s.index_id, b.name, s.avg_fragmentation_in_percent from sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS s inner... Continue Reading →