[<< wikibooks] Design of Main Memory Database System/Query Execution
Joins
Subqueries
Aggregation