As a rule I take the hint.
To switch to Oracle's rule based optimiser use the hint /*+ RULE*/. You can include this in PeopleSoft MetaSQL with something along the lines of: - %InsertSelect(XXX_UK007_BOND2, TL_RAPID_TIME R, JOB J, PROCESS_INSTANCE = /*+ RULE*/ DISTINCT %Bind(PROCESS_INSTANCE)