Linked Server - SQL 2008
831809Jan 17 2011 — edited Jan 18 2011I 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,