1 In this article we will talk about query optimization with the focus on the queries with GROUP BY and ORDER BY.
2 However, if the query does not have the first leftmost part of an index, MySQL will not be able to use it:
3 “AVG” + group by does not work with loose index scan.