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 ...
Published June 30, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.