Say SQL Server Svr1 has a linked server configured called Svr2. Assume there is a view on Svr2 that joins multiple tables from Svr2.
Is there a deterministic way to know where the join (inside the view) and filtering will execute? On Svr1 or Svr2?
Example 1:
select *
from Svr2.db.tbl.viewname
Example 2:
select *
from Svr2.db.tbl.viewname
where col1 = 'test'
I understand that if a join is made, then the SQL Server engine may decide to bring the entire table from Svr2 to Svr1, and then filter and join it. But this question is about a simple SELECT and WHERE.
14