[Question] Semijoin in distributed databases

Assuming we have a distributed database, with tables stored in different servers, and with no replication whatsoever. What kind of situation here would benefit from the use of a semijoin?

Could you give me an example of an SQL query that would benefit from this semijoin?

Thanks in advance!

submitted by /u/imafraidofgrass
[link] [comments]


Go to Source of this post
Author Of this post: /u/imafraidofgrass
Title Of post: [Question] Semijoin in distributed databases
Author Link: {authorlink}