Rebuil Index by ax and slq

(0) Share

Report

Posted on by Rvp_

hello master,

i wanna ask, is that same if we do re-index by ax (System Administration -> Periodic -> Database -> SQL Administration -> Index Actoin -> Re- Index)

and if we do Re-index by query in SQL SERVER ??

Thank you.

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

AX is just going to execute the similar command to what you will be executing in SQL. If you have option and expertise to do from SQL that would be preferred to avoid tying AX resources. Also have re-indexing plan on regular basis.

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (1)

Report

Hi Rahmat,

In AX,You can use the path you mentioned to re-index.

http://dynamicsaxarticles.blogspot.com/2012/11/dynamics-ax-maintenance-re-indexing.html

In SQL Server Management Studio, you can right-click the index you want to reorganize and select Rebuild.

You can read this Doc: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15

Was this reply helpful? Yes No
Rvp_ 89 on at

Like (0)

Report

so it means, it will same if we do in ax or sql right?

Was this reply helpful? Yes No
Rvp_ 89 on at

Like (0)

Report

thank you blue wang

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

End result should be same.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

In SQL, you have more options (reorganize, rebuild, online rebuilding, parameters) than in SQL.

Consider using Ola Hallengren's scripts for index maintenance - .it's more clever than just running the same action for every index.

Was this reply helpful? Yes No