Incorrect SQL formation or optimization is harcoded in the query
The out-of-the-box query contains optimizer_features_enable which is used in hint to force, which makes the optimizer to choose a bad plan.
Steps to Reproduce
A defect in Pegasystems’ code or rules.
- Apply HFix-46290
- Add a new system setting in Pega-RulesEngine 'fua/overrideoracleoptimizerfeaturelevel' as 'false'
- Restart the instance
0% found this useful