Database optimizers are constantly improving. During this session, we will cover the new optimizations implemented by the optimizer team for MariaDB 10.3 release and the planned projects for the next 10.4 release.
* Condition Pushdown through GROUP BY and PARTITION BY
* Split-grouping for derived tables (a guaranteed speedup where the optimization applies)
* Improved Engine-Independent Table Statistics support
* New optimizer default settings