Hi Everyone
my scenario is as follow:
when activating standard cost prices AX performance decreases sensibly.
By tracking the set of queries from SQL during the activation , it turns out that SQL suggests to add a couple of indexes on inventtrans and inventcosttrans.
Now , I tried in a test environment and I have created the indexes from SQL ( not AX) and the cost activation performance improved sensibly.
I know that technically AX is the master and indexes created from sql will be dropped after a sync but in theory is exactly what I want.
As my company calculates the standard cost once or twice a year, the idea would be to create the indexes before rolling the new costs and then drop them after the calculation has been completed.
This will ensure the index creation has not impact on AX and they are used one-off to speed the calculation up.
I would like your thought on this. I am concerned that adding and dropping the indexes directly from SQL will have an impact on AX performance. Is this a possible side effect?
Many thanks
