- 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.
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.
- 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