Skip to main content

Index Tips for Performance improvement in Axapta

There are some Index Tips for Performance improvement in Axapta. You need to take care on index creation.

1. To create Index on table you can go to particular table from AOT then go Index then right click then create new Index.

You should apply naming convention for index as per column added in to index.

Table Index

2. You need to maintain sequence of column in index as suggested through sql performance tuning adviser. There is include column option available in Ax 2012 but in Ax 2009 include column option is not available.

Include column

3. If there is recid field inclusion in index then please avoid this column to include in index because its unique filed and system maintain auto index creation if you select property createrecidx on table to yes .

4. Do not include dataareaid in index column because system take this column by default on all index.

5.After index creation synchronize table from AOT and re-index the table.


Popular posts from this blog

How to set up parent project in project accounting in ax 2012

create simple project and then go to the project hierarchy fast tab and there you must define sub-project ID format "-#" and then your sub-project will be enabled. For resource assigning in Project first you need to configure the HR module, in that you need to maintain the calendar for those employees and then you need to define the cost of that particular employee (for expense) and for Revenue you need to define the sales price of that particular employee. In the project accounting module you need to mention the calendar in scheduling fast tab and then you need to define WBS, in WBS activity you can be able to assign resources.

ERD Account Payable and Account Receivable in ax 2012