Performance-wise, fields in the index should be sorted by selectiveness. Most selective(unique) fields needs to go first and least selective should be in the end of the list.
By default AX kernel creates indexes with dataAreaId field at first position in the index which is good if you work with multiple companies. Position of DataAreaId field
can be changed by adding the dataAreaId as a field in an index:1. right click on the index and click "New Field"2. select dataAreaId in the index field propertiesWhen it is done dataAreaId can be placed at any position in the index(last one in my case). AX kernel will keep that position and won't override it.
No comments:
Post a Comment