join

SQL Join Algorithms: Nested Loop, Merge, and Hash Join

https://medium.com/@milhamsuryapratama/sql-join-algorithms-nested-loop-merge-and-hash-join-f264a34194e3 https://clickhouse.com/blog/clickhouse-fully-supports-joins-how-to-choose-the-right-algorithm-part5 https://readyset.io/blog/introducing-hash-join-algorithm

Nested Loop Join

Sort-Merge Join

Hash Join

GRACE Hash Join https://blog4fun.github.io/blog/2014/01/29/hash-based-join-algorithms-for-rdbms/ "G:\11-joins.pdf" https://habr.com/ru/articles/657021/

Merge Sort

https://www.baeldung.com/java-merge-sort