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

SA-10763

Summary



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.

Resolution



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 ...  
 
Suggest Edit

Published June 30, 2015 - Updated October 8, 2020

Did you find this content helpful? Yes No

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.

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