Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Common Table Expressions in MariaDB 10.2

Common Table Expressions in MariaDB 10.2

 4 October 11:20 AM - 12:10 PM @ St. Gallen
Experience level: 
50 minutes conference
Focus Areas
Tools and Techniques


MariaDB 10.2 introduces support for Common Table Expressions (CTEs). Both recursive and non-recursive CTEs are supported. This talk will cover everything about the CTEs: - What are the recursive and non-recursive CTEs - How they are useful: what kind of information you can compute with CTEs that's difficult to compute otherwise. - How are CTEs computed and what kinds of CTE query optimizations are present in other databases - How CTEs are implemented in MariaDB: what optimizations it has and how it compares to other databases.


Galina Shalygina's picture

Galina Shalygina

Student, Saint Petersburg State University


Galina Shalygina is studying at the Saint Petersburg State University at the Analytical Information Systems department. She has worked on the implementation of Common Table Expressions in MariaDB.

Sergei Petrunia's picture

Sergei Petrunia

Query Optimizer Developer, MariaDB Corporation


Sergei Petrunia is a query optimizer developer at MariaDB Corporation Ab. He implemented MariaDB's optimizer features like Table Elimination (MariaDB 5.1), improvements to semi-join subquery optimizations (MariaDB 5.3/5.5), SHOW EXPLAIN (MariaDB 10.0), and ANALYZE for statements (MariaDB 10.1) Prior to Monty Program, he has worked for MySQL Ab/Sun Microsystems, where he was the author of query optimizer features like Partition Pruning, Index Merge (MySQL 5.1), and numerous smaller improvements in query optimizer and other parts of the server. He maintains a highly technical blog at

Share this talk