mysql 优化左连接_mysql – 左连接优化

SELECT a.col12, b1.col8, c1.col9, d1.col10, e1.col11

FROM a

INNER JOIN (SELECT b.col8, b.col2, b.col3 FROM b

WHERE b.col2 = a.col2 GROUP BY b.col8) b1

ON (b1.col2 = a.col2)

INNER JOIN (SELECT c.col9, c.col3, c.col4 FROM c

WHERE c.col3 = b1.col3 GROUP BY c.col9) c1

ON (c1.col3 = b1.col3)

INNER JOIN (SELECT d.col10, d.col4 FROM d

WHERE d.col4 = c1.col4 GROUP BY d.col10) d1

ON (d1.col4 = c1.col4)

INNER JOIN (SELECT e.col11, e.col6 FROM e

WHERE e.col6 = a.col6 GROUP BY e.col11) e1

ON (e1.col6 = a.col6)

现在您将没有更多重复的行.您可能必须尝试使用​​LEFT而不是INNER连接.如果你不需要一个subselect你应该消除它,因为它减慢了事情.