Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Query execution time on pr_sys_statusdetails table degrades

SA-47447

Summary



Query performance degrades when executing the threshold value in the pr_sys_statusdetails table.

Execution time of the below query is greater than the threshold value.
delete from RSM_WORKER.pr_sys_statusdetails where pxUpdateDateTime < (select TRUNC(max(pxUpdateDateTime), 'DD') - 7 from RSM_WORKER.pr_sys_statusdetails)


Error Messages



Not Applicable


Steps to Reproduce



Run the below query.

delete from RSM_WORKER.pr_sys_statusdetails where pxUpdateDateTime < (select TRUNC(max(pxUpdateDateTime), 'DD') - 7 from RSM_WORKER.pr_sys_statusdetails)


Root Cause



The threshold value is set to 250 millisecond. The default threshold value is 500 milliseconds.


Resolution



As a local-change, increase the threshold value to 500 milliseconds (default value).


Suggest Edit

Published March 9, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us