W3cubDocs

/MariaDB

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? The basic idea behind table elimination is that sometimes it is possible to...
Table Elimination in MariaDB The first thing the MariaDB optimizer does is to merge the VIEW definition ...
Table Elimination User Interface One can check that table elimination is working by looking at the output of...
Table Elimination in Other Databases In addition to MariaDB, Table Elimination is found in both Microsoft SQL Se...
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.

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