Joining to a linked server will also likely have extremely bad performance. Depending on the linked server product and driver, you'll likely get row-by-row processing (cursor) access on the remote side, and you'll definitely copy the entire dataset over to the local server. The query optimizer will be unlikely to use any indexes or other optimizations.