Posted: 29 Jun 2020 21:30 EDT Last activity: 1 Jul 2020 23:54 EDT
Create new columns on pc_assign_workbasket
Due to a business requiment, we need to include 6 new columns to optimize the search on pc_assign_workbasket table. Actually we use a join with pc_work table to filter this columns on the assignment report definition, but the performance is very poor, due to amout of records and custom columns on pc_work table.
Is there any restriction or concert to update the pc_assign_worklist data model?
Basically pc_assign_workbaket is the pega default table for storing the information related to the tasks that are routed to Work Basket. Adding additional custom columns to this table is not a best practice as every time data inserted in to this table values for the custom columns should be inserted else null values will be present. To improve Performance on the Work Table create Data Base Indexes on the columns which you want to utilize as part of the search this will improve the search performance.