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.
Tuesday, September 22, 2015 - 2:10pm @
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 the main query transformations, the join optimizer, the data access strategies,... [read more]
Tuesday, September 22, 2015 - 4:20pm @
There have been substantial improvements to the optimizer in MySQL 5.7—most noticeably, users can now combine relational data with NoSQL. MySQL introduced a new JSON datatype and built-in JSON functions, and functional indexes are now supported through both stored and virtually generated columns. On the performance side, MySQL can avoid creating temporary tables for UNION ALL, enable range scans... [read more]