Hello All.
I have two SQL instances, DEV and TST, on the same box. I have a query that joins a local table with a
remote instance table through a linked server. I
have examined and compared the server settings,
the linked server properties and the table properties
including column definition, indexes, row counts
(each table has identical data), statistics,
filegroup placement, etc. And DEV and TST, including
the table, appear to be identical. The query joins
on a column from the local table and the remote table
and filters rows from the remote table in the where
clause. In DEV, the execution plan shows that the
remote table rows are being filtered in the remote
server before being passed to the local instance.
In TST, the execution plan shows that the rows
are being filtered locally after they were fetched
from the remote server. Can anyone explain to me
why this is happening since there is a significant
difference in performance? Thanks in advance.
dab