On 15-10-28 05:42 PM, Tim Landscheidt wrote:
(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
_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l
MySQL and Maria both support STRAIGHT_JOIN to force join order.
https://mariadb.com/kb/en/mariadb/how-to-force-query-plans/
On a related note, index forcing is not possible when using views to
access underlying tables.
_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l
