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