You'll have to experiment a bit, but there is certainly an Oracle supplied
OLEDB provider and you could also perhaps experiment with the oledb provider
for ODBC running against either the MS or the Oracle odbc driver. I'd
*expect* the Oracle OLEDB provider to be the fastest and most stable but
there is no substitute for testing.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Mark" <mark_at_sherwood.org.uk> wrote in message
news:1d6481cc.0110180338.662264c4_at_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 - 10:23:15 CDT
