Deep Dive – New-style query optimizer hints now in MariaDB

Online Event – 13 Aug 2025, 17:00 CEST – Watch recording!

Sergei Petrunia, MariaDB plc

Presentation

MariaDB’s New-Generation Optimizer Hints: Fine Optimizer Control and compatibility!

MariaDB introduces support for New Generation Query Optimizer Hints!

New optimizer hints

• Allow to control the finest details of the query plan!
• Provide compability with hints in MySQL!
• But go beyond that, we’re adding capabilities that MySQL does not have!

The talk will start with syntax basic and go all the way to discussing the finer details!