Understanding the Planner/Optimizer Pipeline

You will trace the transformation of an SQL query from raw parse tree to an optimized execution plan.