Which is better: Selecting across linked servers vs migrating the database
You'll likely get the best performance by copying the content of the remote table locally first, then running the query.  Especially if you filter the remote table through a remote view or a stored proc on the remote server.  

Joining across a linked server can be brutal on performance depending on the implementation details of the query.