Hi

You can get result in both ways:

1. Linked server

2. Open query

To simplify the query you can create synonym on those tables. This is the normal way to access from another...

Hi,

It's not necessary, plan always should be index seek. Based on volume of table data, index scan will be considered as best plan by the compiler.