Question
Centene Corporation
US
Last activity: 16 Jan 2019 10:23 EST
Performace related issues on Work basket table
I am the DBA working on tuning a query that's gettig operator details from wrokbasket table, the query was working fine until last week. Suddenly the performance got impacted and crossing the threshold limit.
I have checked the stats on table and indexes, everything is updated.
I know pega recommends to do maintenance operation on this table frequently, what sort of maintenance operations are we talking about?
Can anyone help me like what are the routine maintenance to be done to improve the performance.
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
FR
Hello,
Can you clarify, which table is it exactly. What do you mean by: "I know pega recommends to do maintenance operation on this table frequently"? Are you thinking about an article or anything you have seen on the help file?
Centene Corporation
US
It's PC_ASSIGN_WORKBASKET, i got the info from below link.
One more thing i wanted to add, there are many indexes on table that, if i add any index it's not even working but also impacting the other queries other than the query i am trying to fix.
The link also mentions that to split PC_ASSIGN_WORKBASKET into tables, if possible can you tell me how exactly we can do that and will it help improving the performance?
Coforge DPA
GB
Hi
So what exactly is the issue like timeout or taking more time?
From where the query gets triggerred, is it from Pega? As Marc asked, which table you are referring to?
Regards
Bhavya