Uploaded image for project: 'Development'
  1. Development
  2. DEV-7737

Add Index to SO_Main.BillWhenComplete and SO_Main.CreditNote to improve performance

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Backlog
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 07.02.02.00
    • Component/s: General
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              mikes@jiwa.com.au Mike Sheen
              Reporter:
              mikes@jiwa.com.au Mike Sheen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: