W3cubDocs

/MariaDB

Using CONNECT - Condition Pushdown

The ODBC, JDBC, MYSQL, TBL and WMI table types use engine condition pushdown in order to restrict the number of rows returned by the RDBS source or the WMI component.

MariaDB starting with 10.0.4

Since MariaDB 10.0.4, the CONDITION_PUSHDOWN argument is no longer accepted. However, it is not needed because CONNECT now uses condition pushdown unconditionally.

MariaDB until 10.0.4

If the engine condition pushdown is OFF, it is necessary to set it ON with the optimizer_switch setting, for instance by:

set optimizer_switch='engine_condition_pushdown=on';

Or launching mysqld with this parameter set to ON, for instance:

mysqld --console --engine_condition_pushdown=on

Note 1: specifying --console is important to have some error messages from CONNECT printed because MariaDB does not always retrieve them.

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/using-connect-condition-pushdown/