> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables.md).

# Optimizations for Derived Tables

{% columns %}
{% column %}
{% content-ref url="/pages/6IPAVSjLT2CdWxcuscDb" %}
[Condition Pushdown into Derived Table Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/condition-pushdown-into-derived-table-optimization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Y1g5MixePSjm6fCseO0L" %}
[Derived Table Merge Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-merge-optimization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/GTehQgGFNQ79EM2d9JAe" %}
[Derived Table with Key Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/derived-table-with-key-optimization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ljoQ09IvMs3yc7musNWs" %}
[Lateral Derived Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/lateral-derived-optimization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Documents Lateral Derived Optimization, also referred to as Split Grouping Optimization or Split Materialized Optimization.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/kmHcb3Qd5IKozEHl5eFB" %}
[Split Materialized Optimization](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizations-for-derived-tables/split-materialized-optimization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Split Materialized Optimization is another name for the Lateral Derived optimization.
{% endcolumn %}
{% endcolumns %}