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****