Condition Pushdown into Derived Table Optimization
You are viewing an old version of this article. View
the current version here.
If a query uses a derived table, the first action that the query optimizer will attempt is to apply the derived-table-merge-optimization and merge the derived table into its parent select. This is however only possible only for certain kinds of derived tables.
Comments
Comments loading...
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.