DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Linked Server - SQL 2008

831809Jan 17 2011 — edited Jan 18 2011

I am having a problem with Linked Server on SQL 2008 and Oracle 9i, when i query against my linked server to Oracle (ORAOLEDB.Oracle) , the sql server was bringing all the rows in the Oracle database, than filtering in the SQL Server processor. I am doing a simple query (select * from LS...contract where nuContract = 1 ( pk))

fon the Oracle we have 50 millions of contracts,, than i just need one, but the SQL trys to "download" all the table to local, than filter in local.

Thanks for the help,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2011

Added on Jan 17 2011

#oracle-provider-for-ole-db, #performance, #windows-and-net

1 comment

323 views