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