Module
Query Processing and Join Algorithms
Sign in to add this module to your path and practice.
About
Query evaluation pipeline, selection and projection algorithms, external sorting, join methods (nested-loop, block nested-loop, index nested-loop, sort-merge, hash), basic aggregation, and an introduction to cost estimation and query optimization (heuristics and cost-based ideas).
Goal
Select and cost appropriate physical operators (especially joins) for a given query and physical design; outline how a query optimizer might choose a plan.
Unlocks
Tutor
Ask questions about this module.
Hi — I'm your tutor for Query Processing and Join Algorithms. Ask about the concepts, goal, or where you're stuck.