BO4 - Adding oracle hints to queries via BO parameter?

[former_member272336]

Hi,

Is there a way of setting a parameter such that hints can be added automatically at start of BO query, e.g if want all queries to run in parallel

then would want all queries to start SELECT /*+ PARALLEL*/ rather than SELECT.

Alternatively another way of forcing bo queries to run in parallel against the databse.

Thinking of using hint of the connection parameter and putting parallel hint in there.

Connection already exists.

Do we just need to edit the connection and republish and all existing queries will pick this up by default?

Thanks

[Former Member · Accepted solution]

Hello Philip,

You can just edit the connection and add the Hint in the custom parameter for conenctions.. That should work. No specific changes needed.

Regards,

Laxminarayana

[former_member272336 · Accepted solution]

Hi Laxminarayana,

Thanks