Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-6668

CLONE R4 - Add Indexes to FoodDonation tables

    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

      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

          Clones

          Improvement - An improvement or enhancement to an existing feature or task. CFAMX-6667 Add Indexes to FoodDonation tables

          • Major - Major loss of function.
          • In Functional Review

            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.