Search This Blog

Tuesday, August 23, 2011

Performance improvement by changing position of dataAreaId field in index


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 properties
When 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

Thanks for visiting my blog,
I will reply for your comment within 48 hours.

Thanks,
krishna.