-
Type:
Improvement
-
Status: Done
-
Priority:
Backlog
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: 07.02.02.00
-
Component/s: General
-
Labels:None
There is no index on SO_Main.BillWhenComplete Or SO_Main.CreditNote.
Some queries, including those used by our stored procedures such as usp_Jiwa_GetQuantityOpeningBalance which is invoked by usp_JIWA_QuantityAsAt are greatly impacted by this.
Add the following indexes upon upgrade:
CREATE INDEX IX_SO_Main_BillWhenComplete ON SO_Main(BillWhenComplete) CREATE INDEX IX_SO_Main_CreditNote ON SO_Main(CreditNote)
Make sure the script can deal with the indexes already being there, as these have been deployed to a customers site already.