HemanthK7756 Member since 2018 1 post
Centene Corporation
Posted: 1 year ago
Last activity: 1 year 8 months ago

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

Case Management System Administration
Moderation Team has archived post
Share this page LinkedIn