Details

    • Type: Improvement
    • Status: In Functional Review (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2019R4
    • Fix Version/s: None
    • Component/s: Inventory
    • Labels:
      None
    • Sprint:
      CFAMX 2020R1 Sprint 2

      Description

      The tables around Food Donations need to be reviewed and we need to ensure that they have proper indexes and that queries against them are not doing Table Scans.

      I am seeing that tbTransactionFoodDonation has no indexes at all (should at least have a PK) and tbFoodDonationItem has a PK, but since we are joining on ItemID and SalesItemID in qry_MMS_XSLT_FoodDonations, we probably need indexes on those 2 columns at least.

      Please review all the queries against these tables and ensure that they are using decent indexes.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Michael.DeBinder Michael DeBinder (Inactive)
                Reporter:
                Michael.DeBinder Michael DeBinder (Inactive)
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.