Distributed Joins

You are looking at an older version of the documentation. The latest version is found here.

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. Data Virtuality Platform tries to join disparate data sources as efficiently as possible.