Articles about subquery optimizations in MariaDB.
|Subquery Optimizations Map||Map showing types of subqueries and the optimizer strategies available to handle them|
|Semi-join Subquery Optimizations||MariaDB has a set of optimizations specifically targeted at semi-join subqueries|
|Table Pullout Optimization||Table pullout is an optimization for Semi-join subqueries|
|Non-semi-join Subquery Optimizations||Alternative strategies for IN-subqueries that cannot be flattened into semi-joins|
|Subquery Cache||Subquery cache for optimizing the evaluation of correlated subqueries|
|Condition Pushdown Into IN subqueries||This article describes Condition Pushdown into IN subqueries as implemented...|
|Conversion of Big IN Predicates Into Subqueries||The optimizer will convert big IN predicates into subqueries.|
|EXISTS-to-IN Optimization||MariaDB 5.3 introduced a rich set of optimizations for IN subqueries|
|Optimizing GROUP BY and DISTINCT Clauses in Subqueries||MariaDB removes DISTINCT and GROUP BY without HAVING in certain cases|
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.