[Labs-l] query optimization

[Bruce Myers]

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
> Labs-l at lists.wikimedia.org
> 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.