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)

Comments

Popular posts from this blog

Life On Mars Soundtrack

The 100 Best and Absolute Greatest Heavy Metal Albums in the World, Ever.

Pop Quiz