My customer somehow only has SQL Server 2005 instance. It has linked server to oracle database. I've noticed that sql server doesn't send any filters to oracle side and apply them only after it retrieves all data from oracle. Which is quite opposite to work of sql server - sql server linked server.
I'm wondering - could it be because of sql server version? Maybe 2005 is to old for that?
SELECT * FROM OPENQUERY (ORCLLS, 'Select * from ADMIN.IE_Docs_Subscrs where F_DRSO = ''84c9e2c5-2634-4f6a-b1b7-e1505d4a1c39''')
Result: 0 seconds. 24 rows
SELECT * FROM OPENQUERY (ORCLLS, 'Select * from ADMIN.IE_Docs_Subscrs') WHERE F_DRSO = '84c9e2c5-2634-4f6a-b1b7-e1505d4a1c39'
Result: 1m 33 seconds. 24 rows
Got it. It's because of OPENQUERY. But how can I turn it into four-part name?