Can pega case work table (similar like pc_work ) be partitioned?
Our application currently holding huge volume of case data into work table. Even though we are using archival and purging to keep only recent 6 months data but still 6 months volume is too high. client has asked if work table can be partitioned or not. We don't have any prior experience on doing such partitioning on work table and not sure how this will really work as not sure how to let database know that which partition to use when performing insert or update operation on case via standard obj-save method. Any help is very much appreciated.
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.