AX 4.0 Rebuild SQL Server 2005 Indexes RRS feed

  • Question

  • We currently are running AX 4.0 with SQL Server 2005 on the backend.

    Our system is slow at times.  We are planning to rebuild / reorganize the DB tables to help with this issue.

    Some of the tables are of type heap and can only be defragmented by adding a clustered index.  If we do this,  will this break any queries that AX performs?  Is AX expecting (and must have) a heap?


    Friday, June 6, 2014 4:19 PM