Skip to Main Content
Forums

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,

Comments

gdarling - oracle
I don't claim to be a SQLServer guru, or well, even moderately intelligent at it, but you might want to try using OpenQuery instead of linked server directly.

select * from openquery(MYLINKNAME,'select * from table where pk=1)

Hope it helps, corrections/comments welcome.
Greg
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 15 2011
Added on Jan 17 2011
#oracle-provider-for-ole-db, #performance, #windows-and-net
1 comment
322 views