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

Slow performance on query ignoring PRPC hint



An Agent process runs an activity that has RDB-List command, which pulls information from the database directly. It takes a long time duration, due to a Cartesian Join (join between every table). You must be able to an Oracle optimizer hint in the query to fix this, but while it works in the Pre query, the optimization code is absent in the post query.

Error Messages

Not Applicable.

Steps to Reproduce

Run agent Activity with RDB-List command.

Root Cause

PRPC filters out what are considered to be comments in the custom SQL contained in RDB-List rules.  Oracle hints resemble comments and therefore, are filtered.


To avoid PRPC stripping off the hint, do the following:
To submit this as part of the SQL:

    select my_column /* some hint */ from ... 
To set up your RDB SQL to look like this:

    select {AsIs: "/* some hint */"} from ...  

Published June 30, 2015 - Updated October 8, 2020

Was this useful?

100% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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