On Wed, Feb 24, 2010 at 10:11 AM, Yang Zhang <yanghates...@gmail.com> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org