0

In Oracle Data Integrator 12c I have a job that's selecting from quite few number of tables and writing to a file. As suggested by DBA he wanted me to add HINT at the begining of the select query ex:

SELECT
   a.fname,
   a.lname,
   l.abc
FROM
   customers  a,
   location   l,
   region     r
WHERE
 a.xyz =l.xyz and
     l.coloumn = r.coloumn and
       a.id = 1243
   AND b.city = 'new york' .... 

the above needs to be changed to

SELECT
    /*+ leading (a) */ a.fname,
    a.lname,
    l.abc
FROM
    customers  a,
    location   l,
    region     r
WHERE
      a.xyz =l.xyz and
      l.coloumn = r.coloumn and 
        a.id = 1243
    AND b.city = 'new york'....

how to achieve this in ODI and where can I observer the change.

Thank you all

2
  • 1
    It's not clear how you want to join the tables. Please use modern join syntax, instead of the comma-separated list of tables from 1989. Commented Jan 29, 2022 at 2:49
  • 3
    Obviously if the query is generated by ODI you must use some feature of ODI to add the hints. Google for "add hint Oracle ODI" returns results, did you check them? You may also search in the documentation for a check box use ANSI join syntax so that @TheImpaler will be satisfied. Commented Jan 29, 2022 at 9:09

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.