Chapter 4: Joins: Retrieving Data from Several Tables
Relocated joins
Joins between local and remote tables can be relocated to
a remote server. The remote system executes the join using a dynamically
created proxy table referring back to the local table. This avoids
a significant amount of network traffic.