Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
AX 4.0 Rebuild SQL Server 2005 Indexes RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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?

    Thanks

    Friday, June 6, 2014 4:19 PM

Answers