Optimizations for Derived Tables

Optimize derived tables in MariaDB Server queries. This section provides techniques and strategies to improve the performance of subqueries and complex joins, enhancing overall query efficiency.

Condition Pushdown into Derived Table Optimization

Condition Pushdown pushes a parent query's conditions into a derived table or view that cannot be merged, letting the optimizer build efficient access paths.

Derived Table Merge Optimization

Derived Table Merge folds a FROM-clause subquery or view into its parent SELECT when it has no grouping, aggregates, or ORDER BY ... LIMIT, avoiding a temporary table.

Derived Table with Key Optimization

Derived Table with Key lets a materialized derived table have one index that the optimizer uses for joins with other tables instead of a full table scan.

Lateral Derived Optimization

Documents Lateral Derived Optimization, also referred to as Split Grouping Optimization or Split Materialized Optimization.

Split Materialized Optimization

Split Materialized Optimization is another name for the Lateral Derived optimization.

_{This page is licensed: CC BY-SA / Gnu FDL}