> 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/table-elimination.md).

# Table Elimination

{% columns %}
{% column %}
{% content-ref url="/pages/ABXquatIgGLrfzHTC7a0" %}
[Table Elimination External Resources](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-external-resources.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Links to external resources demonstrating table elimination in MariaDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/6LCv6Bov5Y5FOFxQtxsW" %}
[Table Elimination in MariaDB](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-mariadb.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Shows how the MariaDB table elimination module merges a view and removes outer-joined tables that are guaranteed a single match and unused elsewhere in the query.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/9JYWSDgDlULMMFeicEcl" %}
[Table Elimination in Other Databases](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-in-other-databases.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Compares table elimination support in Microsoft SQL Server 2005/2008 and Oracle 11g, noting SQL Server's more advanced handling of subselect join conditions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/6llC8bf5gQIwMDTCzFWs" %}
[Table Elimination User Interface](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/table-elimination-user-interface.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Shows how to confirm table elimination by inspecting EXPLAIN output for absent tables, and notes the debug-build table\_elimination switch.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/c1J7qpVL1h8fbGvYS75F" %}
[What is Table Elimination?](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/table-elimination/what-is-table-elimination.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Introduces table elimination, which resolves a query without accessing some referenced tables, using an Anchor Modeling actors example to show when it applies.
{% endcolumn %}
{% endcolumns %}