Re: EXPLAIN says DEPENDENT SUBQUERY despite no free variables

[Perrin Harkins]

On Wed, Feb 24, 2010 at 10:11 AM, Yang Zhang <yanghatespam@stripped> wrote:
> Any ideas on
> how to optimize this by convincing mysql to see the independence use a
> const join?

http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/

You need to rewrite as a join or use a FROM subquery.  You should
pretty much always avoid using IN/NOT IN.

- Perrin