Hi,

SQL queries in the attached xlsx are related to Rule ABA Cache population. In other words, the ABA cache was being primed for the first time after you did an application deployment or upgrade. Once the cache is primed you should not be seeing these PEGA0005 Alerts for the same queries. 

The magnitude/impact of the queries in terms of time taken to execute is not considerably high than the OOTB threshold of 500ms. However, if you would like to improve the query execution times, it is recommended to update the statistics explicitly of the following tables on a periodic basis.

 

pr_sys_app_hierarchy_flat

pr_sys_app_ruleset_index

pr4_rule_vw

pr_sys_appcache_dep

pr_sys_class_ancestors

 

SQL:- UPDATE STATISTICS <schema>.<table_name> WITH FULL SCAN