Intermittent Inventory On Hand Performance Issues

(0) Share

Report

Posted on by XB

1,867

Often we have a poor performance of InventOnHand Form, I saw this link with recommendations:

https://blogs.msdn.microsoft.com/axsupport/2016/05/11/intermittent-inventory-on-hand-performance-issues-queries-on-inventsum-inventdim-whsinventreserve-tables/

Create Index [Index name] On INVENTSUM (ITEMID, CLOSED, DATAAREAID, PARTITION)

They talk about create an index on inventSum in my version this index exists on the standard but the order of the fields is differents, We have first Closed and the Item, and If I search in code if it's used, and the Item field is firts in where clause.
Is it recommendes to set first Itemid on index?

7853.1.png