Problem regarding MySQL query with oracle.

Asked By 10 points N/A Posted on -
qa-featured

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.

Yelverton Nolan

SHARE
Answered By 0 points N/A #170943

Problem regarding MySQL query with oracle.

qa-featured

A foreign-data wrapper (FWD) in {an exceedingly|in a very} Postgres server permits to fetch information from a foreign entity or an overseas server. During this case, the Postgres planner and executer have the notion of what man's known as an overseas scan, which may be known as victimization custom-made routines and fetch information that man's circuitously hold on within the Postgres server itself.

Login/Register to Answer

Related Questions