Hi All,
I would like to add my note on Driving_site hint in the discussion.
can we use this hint for multiple remote tables in single sql query like as below?.
Ex :
SELECT /*+ DRIVING_SITE(b,c)*/ * FROM emp a,dept@dblink b ,dept2@dblink c
WHERE a.deptno = b.deptno and c.deptno=b.deptno;
Please advise with your suggestions.
Thanks.