-
Type:
Bug
-
Status: Done
-
Priority:
Backlog
-
Resolution: Done
-
Affects Version/s: 07.02.01.00
-
Fix Version/s: 07.02.02.00
-
Component/s: General
-
Labels:None
IN_TransferLines has no indexes on the FromPartInventoryID or ToPartInventoryID, FromPartNo or ToPartNo columns, making functions such as the transaction listing on the inventory maintenance form slow.
Suggest creating the following indexes:
CREATE INDEX IX_IN_TransferLines_FromPartInventoryID ON IN_TransferLines(FromPartInventoryID)
CREATE INDEX IX_IN_TransferLines_ToPartInventoryID ON IN_TransferLines(ToPartInventoryID)
CREATE INDEX IX_IN_TransferLines_FromPartNo ON IN_TransferLines(FromPartNo)
CREATE INDEX IX_IN_TransferLines_ToPartNo ON IN_TransferLines(ToPartNo)