I'm trying to port an application from SQL Server to MySQL (5.6.4) and running into performance issues ... AS p ON t.upc=p.upc In MySQL, the same query thrashes really hard.