Inner Join vs Inner Remote Join when dealing with Linked Servers

Linked Server

• The bottom line is that linked servers are always slow.
• Try to run queries on the remote server or try to push data from the remote server.
• Also look for ways to replicate data from the remote server locally.

Remote Join

When you use the INNER REMOTE JOIN hint you are forcing the tables to be joined in the order as written rather than allowing it to explore all possible join permutations.

Remote Join

• This is useful when the left table is a local table and the right table is a remote table.
• REMOTE should be used only when the left table has fewer rows than the right table