How JOINs work

Understanding the three classical JOIN algorithms – NestedLoop, HashJoin, MergeJoin – how they take advantage of different indexes and how they behave when there is no index can give you a lot of insight on how databases run queries. (Felipe Oliveira Carvalho, 2019)

Bibliography

Carvalho, F. O. (2019). Demystifying Join Algorithms. Retrieved from http://blog.felipe.rs/2019/01/29/demystifying-join-algorithms/. Online; accessed 03 February 2019.