if join remote table and local table, one execution plan is
1: fetch the data from remote, and then run the sql at local.
2: push the data to remote, and execute the sql on remote, and fetch the result back.
which one is better depends. Does sql server support to use hint to use plan 1 or plan 2?
View Complete Post