MySQL Subquery Optimization and using UPDATE with ...

2009年4月3日 - MySQL Subquery Optimization and using UPDATE with INNER JOINs ... table1 WHERE datefield IN (SELECT datefield FROM table2 GROUP BY datetype) ... The solution is to use an INNER JOIN and subquery instead.

jonahellison.com