MySQL Query Optimizer Overview
This presentation gives an introduction to the MySQL query optimizer. Knowing how queries are optimized and executed will help you write better performing queries. The main phases of the MySQL optimizer and the main optimization strategies are presented. Examples of optimization strategies that will be presented are query transformations, data access strategies, the range optimizer, the join optimizer, and subquery optimization. An overview of the cost model and how the optimizer does cost estimations are included. New optimizations introduced in MySQL 5.7 will be included in the presentation.
Senior Principal Software Engineer, Oracle
Olav Sandstå is a Senior Principal Software Engineer in the MySQL group at Oracle, where he works on the MySQL Query Optimizer. Before joining the MySQL team he worked on performance improvements for the Apache Derby database. Prior to that he worked for 10 years on development of Clustra, a highly available DBMS. Olav has PhD from the database research group at the Norwegian University of Science and Technology.