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)


Carvalho, F. O. (2019). Demystifying Join Algorithms. Retrieved from Online; accessed 03 February 2019.