RE: Linked server for Oracle on SQL server - query performance

From: ETT (ETT_at_discussions.microsoft.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 05:25:03 -0700

Hi everybody,

I am experiencing the same problems as explained below. Help is appriciated.

ETT

"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.
>

Relevant Pages

  • Re: ADO.NET the fastest? My foot!
    ... variety of data providers, but they're all ADO.Net Data Providers. ... The Microsoft provider for Oracle ... You're not factoring in database connection times (are you using pooled ... are as follows - it is an average of five executions of the same query. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Injection
    ... > I am currently pen-testing a web app and I am stuck in trying to execute ... two queries sequentially in Oracle. ... You won't have luck with this in Oracle. ... the end query build by a cgi-script being ...
    (Pen-Test)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • External data connection needs separate login for each query
    ... I have an Excel 2007 workbook with multiple external queries to Oracle. ... cached credentials to authenticate. ... credentials for each new query that runs. ...
    (microsoft.public.excel.misc)