Managing The Order Of Tables Or Joins In The FROM Clause Of SQL Code Generated By ODI
(Doc ID 424213.1)
Last updated on OCTOBER 04, 2022
Applies to:Oracle Data Integrator - Version 10.1.3.4.0 and later
Information in this document applies to any platform.
For more information reference: <Document 456313.1> Primary Note For Oracle Data Integrator (ODI) and Legacy Sunopsis, Releases and Patches
In order to optimize the code generated by Oracle Data Integrator (ODI) , it would be interesting to be able to manage the order of the tables or join clauses in the 'FROM' clause of the SQL code generated by ODI.
Is this possible ?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|If you are working on a technology that supports ORDERED JOINS ("Ordered Join (ISO)" checked)|
|If you are working with a technology that does not support ORDERED JOINS.|