[Labs-l] query optimization

Tim Landscheidt tim at tim-landscheidt.de
Wed Oct 28 21:42:34 UTC 2015


(anonymous) wrote:

> Actually using the date as the first filter rule will improve performance
> because the IN filter then only has to be applied to a small subset instead
> of all revisions.

> […]

Does MySQL/MariaDB honour the order of those expressions?
Usually, a database determines the order of best performance
(for the actual data sets at that time) by itself.

Tim




More information about the Labs-l mailing list