The MySQL query optimizer has different strategies available to
evaluate subqueries. For
=ANY) subqueries, the optimizer has these
NOT IN (or
<>ANY) subqueries, the optimizer has
The following sections provide more information about these optimization strategies.