Set parallel hint for specific DB table

[Former Member]

Hi,

  In Information Design Tool, we can set a parallel hint in the Connection parameter value so that all BO query will be added /*+ parallel (16)*/ (please see below picture).

  After the setup, the BO query will contain /*+ parallel (16)*/ in all queries (please see below picture).

  But can we specify which table in the query will have /*+ parallel (16)*/  instead of all tables in the query will have /*+ parallel (16)*/? Thanks.

[former_member182521]

Try to specify the optimizer hint in an custom SQL rather than automatically generated script above.