Table Elimination

Learn about table elimination for query optimization in MariaDB Server. This section explains how the optimizer removes unnecessary tables from query plans, improving performance.

Table Elimination External Resources

Links to external resources demonstrating table elimination in MariaDB.

Table Elimination in MariaDB

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.

Table Elimination in Other Databases

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

Table Elimination User Interface

Shows how to confirm table elimination by inspecting EXPLAIN output for absent tables, and notes the debug-build table_elimination switch.

What is Table Elimination?

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