Distributed Joins

Difference between Joins in the Same Database

Distributed joins work differently from joins in a single database. For example, joining two tables from the same database is executed directly on the RDBMS having local access to both tables. In a federated join, the joined tables are on different databases and can not be joined on the source system. CData Virtuality tries to join disparate data sources as efficiently as possible.