OLE DB Connection performance

From: Mark <mark_at_sherwood.org.uk>
Date: 18 Oct 2001 04:38:41 -0700
Message-ID: <1d6481cc.0110180338.662264c4@posting.google.com>

On a SQL server 2000 server when connecting to an Oracle 8 Server that is connected as a linked server using Microsoft OLE DB Provider for Oracle. A simple query, which returns two fields from one table using a condition that, returns only one record on an indexed field. This query takes about 18 seconds to run when connecting through the SQL Query Analyser.

When the same query except the reference to the linked server in a Oracle SQL Plus 8 client the query runs instantly.

Is there another driver to connect to the Oracle server as a linked server that has better performance? Received on Thu Oct 18 2001 - 06:38:41 CDT