…? The reason is normally table design and understanding inner works of MySQL. If you design your …for completely disk bound workloads. There are certain optimizations in works which would improve performance of …gap but I doubt it will be closed. Joins Joins are used to compose the complex object …
Post: MySQL Limitations Part 3: Subqueries
October 25, 2010 By 21 Comments
… a.id in (select id from b); Users expect the inner query to execute first, then the results to be substituted… to make the inner query dependent on the outer query, which could be an optimization in some cases, but de-optimizes the query… it. And many MySQL users have learned to simply write JOINs instead, so it isn’t that much of a limitation…
