When the subselect runs faster
MySQL Performance Blog
A few weeks ago, we had a query optimization request from one of our customer. The query was very simple like: This column in the table is looks like this: The table have 549252 rows and of course, there is an index on the col1. MySQL estimated the…
18 March 2010