On Thu, Feb 25, 2010 at 2:48 AM, Dan Nelson <dnel...@allantgroup.com> wrote: > IN is fine ( for example ... WHERE field1 IN (1,2,3,4,5,6) is extremely > efficient);
Yes, I meant to say IN/NOT IN subqueries, not value lists. > it's subqueries in general that are killers. Subqueries in the FROM clause (aka derived tables) work pretty well, acting as an in-line temp table. Other subqueries perform poorly, as you say. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org