Query Optimizer in MariaDB 10.0 — Now Even Without Indexes
summary
MariaDB 10.0 query optimizer improvements that let it handle queries even without indexes; the talk describes changes in the optimizer behavior, the problems caused by missing indexes, and how the optimizer's algorithms and execution plans were adapted to work effectively without relying on indexes.
AI-written summary · about
related talks
28mMysql Optimizer Features in 5.7 and 8.0
42mMariaDB and MySQL — What Statistics the Optimizer Uses
53mMariaDB Server 10.2: The Complete Guide
27mAnalytical Queries in MySQL
41mMySQL Query Optimization Best Practices and Indexing
01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries
49mIt’s Not Always About the Index: The Hidden Secrets of Query Performance
57mMariaDB 10.5 Tutorial - New Features for Troubleshooting