We have problem when we want catch data from Oracle XE 21c over db link from database MySql 8.0.32, when we use where condition on select the results are waiting for a very long time.
For example :
MySQL
select * FROM MO_V_PARTNERI; /* Affected rows: 0 Found rows: 18.759 Warnings: 0 Duration for 1 query: 13,781 sec. */
select * FROM MO_V_PARTNERI where sif_par = '059666436'; /* Affected rows: 0 Found rows: 1 Warnings: 0 Duration for 1 query: 0,015 sec. */
Oracle
select * from mo_v_partneri@DB_LINK_TEST; 30,762 sec.
select * from mo_v_partneri@DB_LINK_TEST where sif_par = '059666436'; - this one is never executed
Does anyone have any solution ?