Query Optimizer
Articles about the MariaDB query optimizer
-
Optimization Strategies
Various optimization strategies used by the query optimizer. -
Optimizations for Derived Tables
Optimizations for derived tables, or subqueries in the FROM clause -
Optimizer Trace
Produces a JSON trace with decision info taken by the optimizer during the optimization phase. -
Statistics for Optimizing Queries
Different statistics provided by MariaDB to help you optimize your queries -
Table Elimination
Resolving queries without accessing some of the tables the query refers to -
Block-Based Join Algorithms
Algorithms that employ a join buffer for the first join before starting to look in the second. -
Condition Selectivity Computation Internals
How the MariaDB optimizer computes condition selectivities. -
Extended Keys
Optimization using InnoDB key components to generate more efficient execution plans. -
MIN/MAX optimization
How MIN and MAX are optimized -
Optimizer Debugging With GDB
Useful things for debugging optimizer code with gdb. -
Rowid Filtering Optimization
Rowid filtering is an optimization available from MariaDB 10.4. -
The Optimizer Cost Model from MariaDB 11.0
The optimizer cost model in MariaDB 11.0.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
