Problem regarding MySQL query with oracle.
Hello to the whole community of TechyV!
I have a problem regarding mysql query with oracle. I have recently used Heterogeneous connection between oracle 10204 to Mysql database. Also I have a database link on the oracle side. I have a query table that has 10 million rows in my MySql. It seems that the MySql is fetching all the rows from the table, all the data is transferred to oracle over the DBLink, and only after the requested rows have got back to the client. What seems to be the problem? Any help would be nice. Thanks.