Re: Linked server for Oracle on SQL server - query performance
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/15/04
- Next message: Patrick24601: "IIS and SQL Server Persmission Issue"
- Previous message: Dejan Sarka: "Re: Trace Flag 1807"
- In reply to: Sat: "Linked server for Oracle on SQL server - query performance"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 15 Aug 2004 13:23:15 -0600
How are you querying the table for the linked server? If you
are using the 4 part name, try using an Openquery instead.
Openquery will likely be faster.
-Sue
On 11 Aug 2004 15:15:34 -0700, appu32@yahoo.com (Sat) wrote:
>Hi folks,
>
>I have created a linked server on SQL server 2000 for an Oracle 8i
>database using Microsoft's OLE provider for ORACLE. The connection
>works fine and I am able to run queries (select queries) agaist the
>Oracle table from SQL query analyzer.
>
>But the problem is, the query is miserably slower than if I run the
>query directly on the Oracle table using either SQL*plus or TOAD. In
>the former case (linked table) the query run time is upwards of 7
>seconds whereas, in the latter case (directly using SQL*plus) the
>query runs in 200 milli seconds. The table is indexed and I am hitting
>the index columns.
>
>Any ideas or suggestions? As always thanks in advance and your help
>will be much appreciated.
>
>Appu.
- Next message: Patrick24601: "IIS and SQL Server Persmission Issue"
- Previous message: Dejan Sarka: "Re: Trace Flag 1807"
- In reply to: Sat: "Linked server for Oracle on SQL server - query performance"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
