A distributed query is a query typically involving more than one database server. The following screenshot shows how they work together:
Let's take a look at the preceding screenshot. Source connection is the connection established from a user or application to the server known as the Local Server. The term local does not mean that the user must be logged locally to the server; it means that the server typically processes user queries locally. The Remote Server is then the one that hosts the database remotely from the Local Server. When a user issues a query to the Local Server using remote data, the Local Server divides ...
