Table Elimination

Articles about Table Elimination, the idea that it is sometimes possible to resolve a query without accessing some of the tables the query refers to.

Title Description
What is Table Elimination? Resolving a query without accessing some of the tables that the query refers to.
Table Elimination in MariaDB Table elimination in the MariaDB optimizer.
Table Elimination User Interface Table Elimination User Interface and EXPLAIN.
Table Elimination in Other Databases Table Elimination in SQL Server and Oracle.
Table Elimination External Resources an example of how to do this in MariaDB
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/table-elimination/