Tag Info

New answers tagged


Your issue is due to the sub-query. There are two problems with this: MySQL does not know how to project the outer queries predicates, limits etc. to the inner query, so the inner query ends up being fully materialized ( and then, as a second step, filtered based upon the outer queries. (http://dev.mysql.com/doc/refman/5.6/en/subquery-optimization.html) ...

Top 50 recent answers are included