Hello,
In order to optimise a distributed query, I used the "Driving_site" hint
select /*+ DRIVING_SITE (s1) */ * from Table1 s1 WHERE condition in (select att1 from local_table) ; -- query n°1
select /*+ RULE DRIVING_SITE (s2) */ * from Table2 s2 where condition in (select att1 from local_table); --query n°2
These two queries work fine but once I join the to obtain the desired result in this way:
select * from
select /*+ DRIVING_SITE (s1) */ * from Table1 s1 WHERE condition in (select att1 from local_table) ,
select /*+ RULE DRIVING_SITE (s2) */ * from Table2 s2 where condition in (select att1 from local_table)
where att_table_1 = att_table_2
I don't get the desired execution_plan and the query is rewritten using both subqueries in one of the servers, and the query execution runs in an endless way.
Do anyone know the correct fix for such issue?