The query optimizers job is to generate an efficient execution plan. In this presentation we will give an introduction to the main building blocks and strategies of the MySQL Query Optimizer.