Microsoft Dynamics AX (Archived)

Creating multiple table indexes at once

(0) Share

Report

Posted on by Melvin Steenkamp

I received a list of missing AX 2012 indexes. I need to create these missing indexes in AX.

Is there a way to do this via a job in AX or do I need to create each index manually in the AOT Tables?

Regards

Melvin

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Hi Melvin,

you already asked the same question a couple of days ago, and received some answers: community.dynamics.com/.../290498

You can continue the discussion in that thread if you still have some open questions.

If you don't have open questions anymore, please mark the answers as verified in that thread.

Was this reply helpful? Yes No
Verified answer

A.Prasanna 8,223 on at

Like (0)

Report

Hi Melvin,

I had same issue , but the advice is not to create all the missing indexes .Adding Indexes wont always increase the Performance , some time there will be negative impacts.

Refer these Links : https://docs.microsoft.com/en-us/dynamicsax-2012/developer/best-practices-for-indexes

: https://community.dynamics.com/ax/f/33/t/226367

For more information.

Thanks & Regards,

Amith Prasanna

Was this reply helpful? Yes No
Verified answer

guk1964 10,888 on at

Like (0)

Report
I would do it manually.

You might want to analyse those first. Every added index takes longer to write to and bloats the database. (every insert, update and delete),

Adding indexes to tables that are mainly used for write rather than read should be avoided e.g InventTrans. There are many indexes that can often be usefully be removed to improve performance. So look in the query plan to see how frequently the table is accessed..

See these posts for some useful insights

. http://dynamics-ax.blogspot.com/2009/06/getting-most-out-of-dynamics-ax_16.html

About the SQL Server Missing Indexes Feature: https://technet.microsoft.com/en-us/library/ms345524(v=sql.105).aspx

Limitations of the SQL Server Missing Indexes Feature: https://technet.microsoft.com/en-us/library/ms345485(v=sql.105).aspx

Many programmers get used to not including DataAreaId or Partition in a query because when they call a statement from X++, DataAreaId and Partition are not needed. When there is only one company, the query will return the same results as it does from within Dynamics AX. The issue with calling a SQL Query without adding DataAreaId and Partition is that most indexes on Dynamics AX tables start with DataAreaId and Partition. When you do not use DataAreaId and Partition, SQL cannot traverse the index to answer your query.

Was this reply helpful? Yes No

Community site session details

Creating multiple table indexes at once

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Creating multiple table indexes at once

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates