No. If I add a trivial record restriction (e.g., LIMIT 1) I can get an in-memory temporary table ... two engines too different for comparison? edit: I forgot to mention - don't do subqueries with ...