-
Type:
Story
-
Status: Closed (View Workflow)
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Sprint:CFAMX 2020R3 SA Sprint 4, CFAMX 2020R3 SA Sprint 5
-
SCRUM Team:Watchmen
-
Story Points:13
-
Work Type Classification:Sustaining
Apply Partitioning on tbTransactionItem
Create a Partition Function
Create a Partition scheme
Modify the queries existing table make sure they all use the partition key
Create Script to copy the data over(check Ops if they have any)
Create a job to update partition key for the future
Sales Performance Testing (Iris) Before and After Comparision needed
Every modified query also should have a before-after test (Execution Plan needs be checked if the query is using the right indexes)
- implements
-
CFAMX-9527 Database Partitioning
-
- In Development
-
- is blocked by
-
CFAMX-11791
2021.R1(Partitioning): Generated Forecast Values are not as expected
-
- Done
-
-
CFAMX-11792
2021.R1(Partitioning): UPT Values in tbEntityItem are not as expected
-
- Done
-
