Question

3
Replies
82
Views
Close popover
Hemanth Koleti (HemanthK7756)
Centene Corporation

Centene Corporation
US
HemanthK7756 Member since 2018 1 post
Centene Corporation
Posted: January 14, 2019
Last activity: January 16, 2019
Closed

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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.