February 2, 2005 at 8:28 am
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
February 7, 2005 at 8:00 am
This was removed by the editor as SPAM
February 8, 2005 at 1:54 pm
It seems that the dataset is getting processed on the server side in one case compared to the client side on the second one. somethings you might want to check are the MDAC versions on both server and try creating the linked server by specifying a different driver.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply