0

Basically I am a database Admin, New to Dynamics AX, How to create Index (Clustered and Non Clustered Index) in Dynamic AX Using AOT?

If I synchronize the AX, The index will be removed?

Is there any method available to create Index with Include Clause in AX 2009 Edition?

How to create index using Jobs?

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
user1835120
  • 1
  • 1
  • 1

1 Answers1

3

Do not mess with AX tables, fields, views or indexes using SQL DDL. Because any updates done outside AX may be deleted when synchronizing.

Links:

Included columns in indexes are available in AX 2012, but not in AX 2009.

While creating indexes from an AX job is possible, it is not worth it, because you will have to manually consider each index.

Update:

Just to be clear, unlike other environments, indexes in AX are not done by writing scripts, they are done by manually adding or changing meta-data properties as described in the first link. The actual SQL database indexes are created when the table is synchronized which usually is done automatically when the meta-data are saved.

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
  • +1 DB Admins always think it is okay to just steam into a DB (particularly AX) without any knowledge of the software itself. – AnthonyBlake Nov 19 '12 at 09:28
  • Could you plz suggest some X++ script to add index using AOT? Iam trying to create some missing index, so only few index need to be created. – user1835120 Nov 19 '12 at 10:12
  • If only few, do them by drag and drop. If you are an expert X++ hacker go ahead: http://techstack.com/forum/microsoft-dynamics-ax/57528-8235-1-how-create-index-table-x.html, beware it is not fully working :) – Jan B. Kjeldsen Nov 19 '12 at 11:05