Query Optimizer in MariaDB 10.0 — Now Even Without Indexes
summary
Covers improvements in the MariaDB 10.0 query optimizer that allow it to produce efficient execution plans even when no indexes are available. Explains which optimizer techniques and planner changes were implemented to handle full-table scans and join planning without indexes, and discusses practical impacts for high-load systems.
AI-written summary · about
related talks
28mMysql Optimizer Features in 5.7 and 8.0
42mMariaDB and MySQL — What Statistics the Optimizer Uses
27mAnalytical Queries in MySQL
53mMariaDB Server 10.2: The Complete Guide
01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries
41mMySQL Query Optimization Best Practices and Indexing
34mCommon Table Expressions and Window Functions simple, maintainable, fast queries
49mIt’s Not Always About the Index: The Hidden Secrets of Query Performance