-
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
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.
- Is Clone Of
-
CFAMX-6668 CLONE R4 - Add Indexes to FoodDonation tables
- In Functional Review