Details

    • 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

      Description

      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)

       

       

       

       

       

       

        Attachments

        1. copy_tbtransactionitem_table_data.txt
          0.9 kB
          Caner Saritac
        2. Create_TbTransactionItemTable.sql
          2 kB
          Caner Saritac
        3. image-2020-06-01-07-05-47-149.png
          56 kB
          Caner Saritac
        4. tbTransactionItem_partition_function_and_scheme_script.sql
          2 kB
          Caner Saritac

          Issue Links

            Activity

              People

              • Assignee:
                caner.saritac Caner Saritac
                Reporter:
                caner.saritac Caner Saritac
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 176h Original Estimate - 176h
                  176h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 220h 40m
                  220h 40m

                    PagerDuty

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