Articles about subquery optimizations in MariaDB.
-
Subquery optimizations map
Below is a map showing all types of subqueries allowed in the SQL language,... -
Semi-join subquery optimizations
MariaDB has a set of optimizations specifically targeted at semi-join subq... -
Table pullout optimization
Table pullout is an optimization for Semi-join subqueries. The idea of Tab... -
Non-semi-join subquery optimizations
Certain kinds of IN-subqueries cannot be flattened into semi-joins. These ... -
Subquery cache
The goal of the subquery cache is to optimize the evaluation of correlated ... -
Optimizing GROUP BY and DISTINCT clauses in subqueries
A DISTINCT clause and a GROUP BY without a corresponding HAVING clause have...
