Hi, I have one Oracle fdw table which is giving performance issue when joined local temp table gives performance issue.
select * from oracle_fdw_table where transaction_id in ( select transaction_id from temp_table) ---- 54 seconds. Seeing HASH SEMI JOIN in EXPLAIN PLAN. temp_table has only 74 records. select * from from oracle_fdw_table where transaction_id in ( 1,2,3,.....,75)--- 23ms. Could you please help me understand this drastic behaviour change? Regards, Aditya.
