Invent closing slow

The following added indexes did the trick for us:

InvenSettlement

  • SettleTransIdx (set as ClusterIndex on table properties)
    1. SettleTransId
    2. Cancelled
    3. SettleType
    4. QtySettled

InventTrans

  • InventRefTransIdx
    1. ItemId
    2. ValueOpen
    3. InventRefTransId
  • StatusIssueIdx
    1. ItemId
    2. ValueOpen
    3. StatusIssue
Advertisements