Improved Query Performance by Using Derived Table instead of IN-subquery

(Øystein Grøvlen) MySQL 5.6 introduced semi-join transformation for IN-subqueries. This opened up for several new ways to execute such subqueries; one was no longer tied to executing the subquery once for every row of the outer query.

Read More - Register for Free Membership