Query optimization and execution


Phases of query processing
Semantic query transformations
How the optimizer works
Query execution algorithms
Reading execution plans
Physical data organization and access