SELECT table1.id, table2.id FROM table1 LEFT OUTER JOIN table2 FORCE INDEX FOR JOIN (table1_id) ON (table2.table1_id = table1.id) Reference: https://stackoverflow.com/a/1272402
SELECT table1.id, table2.id FROM table1 LEFT OUTER JOIN table2 FORCE INDEX FOR JOIN (table1_id) ON (table2.table1_id = table1.id) Reference: https://stackoverflow.com/a/1272402