Oracle_FDW table performance issue

[aditya desai <admad123@xxxxxxxxx>]

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.