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