Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) DynamicsPerf lots of I...

DynamicsPerf lots of Indexes missing in AOT

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello All,

According to DynamicsPerf (Indexes_In_DB_Not_In_AOT) we have several thousand indexes that aren't defined in the AOT, is this normal? Also are we checking for this so they don't get removed on system updates or can missing indexes in the AOT affect performance?

Thanks

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Rudi Hansen 3,987 on at

Like (0)

Report

RE: DynamicsPerf lots of Indexes missing in AOT

Normally for an AX database, all indeses should exist in the AOT, is not they might be deleted on an AX syncronise.

It should not affect performance.