Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server // Query doesnt use Index Expand / Collapse
Author
Message
Posted Tuesday, July 21, 2009 1:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 24, 2010 1:20 AM
Points: 9, Visits: 66
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
Post #756350
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse