I liked the article a lot. For more detail its worth looking at: Join Processing in Relational Databases, Priti Mishra and Margaret H. Eich, ACM Computing Surv

I liked the article a lot. For more detail its worth looking at: Join Processing in Relational Databases, Priti Mishra and Margaret H. Eich, ACM Computing Surveys (CSUR) Surveys, Volume 24 Issue 1, March 1992, Pages 63 - 113 via http://www.allthingsdistributed.com/2013/04/join-processing-relational-databases.html http://www.allthingsdistributed.com/2013/04/join-processing-...