In SQL Server these queries will run in roughly the same time. In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the ...