Linked Server // Query doesnt use Index

  • Environment:

    SQL 2005 with SP3

    Linked Server = Oracle 11g Server

    We are using the Oracle 10g Client

    If I made a query the duration takes a very long time until i get the results.

    In the Oracle Session Manager I saw that the SQL Server wasnt using the Oracle index. How could I force the SQL Server to use the Oracle indexes?

    Our Providers (OraOLEDB.Oracle) settings:

    "Allow inprocess" and "Supports 'Like' operator" is activated, the rest is deactivated.

    Our Linked Server Properties:

    The follow settings are "True":

    "Collation Compatible"

    "Data Access"

    "Use Remote Collation"

    Any help would be appreciated

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply