I have a linked server to Oracle (I have one using MS and one Using Oracle
Driver), both take about 20+mins to return 114k rows using OPENQUERY, is
there any way to speed this up, and why does oracle always ruin my day ?

- David

It depends on the query being executed, capabilities of the
driver or provider you are using, connection between the
servers, etc. Have you tried using an OLE DB provider
instead of an ODBC driver? Check the network connection
between the two servers. You may want to go through the
following topic in books online:
Optimizing Distributed Queries
In addition, the following link has some suggestions:
http://www.sql-server-performance.com/linked_server.asp

-Sue

On Mon, 19 Sep 2005 14:56:15 -0400, "David J. Cartwright"
<davidcartwright@hotmail.com> wrote:

>I have a linked server to Oracle (I have one using MS and one Using Oracle
>Driver), both take about 20+mins to return 114k rows using OPENQUERY, is
>there any way to speed this up, and why does oracle always ruin my day ?
>
>- David
>