Problem regarding MySQL query with oracle.

Asked By yelverton nolan 10 points N/A Posted on - 02/19/2013

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

• Status: Open
• Question Views: 660
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By John Doctorr 0 points N/A #170943

Problem regarding MySQL query with oracle.

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.

About John Doctorr

Questions
2

Answers
31

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 03/07/2013
• Question Category: MS SQL Server