[mariadb-query-optimization] "Bounding Expensive Queries: LIMIT ROWS EXAMINED"

[federico-razzoli]

I think there are important things to mention here:

• LIMIT ROWS EXAMINED will generally work when this will cause the results to be incomplete but correct. It will not work when it might cause the results to be incorrect (SELECT COUNT(*)). It is good to check if the query returned an error.
• When the query executed correctly, it's still good to check for warnings to know if the query examined all the rows it needed or not.