#joins

Query Execution - Joins

A practical tour of database join execution, including nested-loop, block nested-loop, index, sort-merge, and hash joins.