This article describes Condition Pushdown into IN subqueries as implemented in MDEV-12387.
optimizer_switch flag name: condition_pushdown_for_subquery
.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/condition-pushdown-into-in-subqueries/