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 -
Notes When an Index Cannot Be Used
Notes (low severity warnings) when an indexed column cannot use the index to lookup rows. -
Optimizer Debugging With GDB
Useful things for debugging optimizer code with gdb. -
Optimizer Development
Notes about Optimizer Development mysql-test InnoDB Estimates are unstable... -
optimizer_max_sel_arg_weight
Limit to reduce the number of ranges generated by dropping restrictions on ... -
Range Optimizer
Range optimizer is a part of MariaDB (and MySQL) optimizer that takes as i... -
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.
