Please re-read Section 4.4 of Joseph Hellerstein and Michael Stonebraker. The Anatomy of a Database System. In Red Book (4th ed).
Paper to review: Leonard Shapiro. Join processing in database systems with large main memories. ACM Transactions on Database Systems 11(3), 1986. Also in Red Book (3rd and 4th ed) pdf