Linked Server // Query doesnt use Index

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Haidong Ji » Linked Server // Query doesnt use Index

Linked Server // Query doesnt use Index

Rate Topic

Display Mode

Topic Options

Author

Message

simon.ciglia

Posted Tuesday, July 21, 2009 1:08 AM

Forum 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 »

Permissions