USE test; DELETE QUICK FROM delete_tbtest_no_part.* USING ( ( delete_tbtest_no_part ) RIGHT JOIN ( test.delete_tbtest_part_01 PARTITION (p0,p1) table_DELETE_MultipleTable_Join_1192 FORCE INDEX FOR ORDER BY (idx_uni) FORCE KEY FOR JOIN (idx_uni,idx_n,idx_f,idx_d) ,delete_tbtest_no_part_01 table_DELETE_MultipleTable_Join_1193 FORCE KEY FOR GROUP BY (idx_n) FORCE INDEX (idx_n,idx_d) ) ON delete_tbtest_no_part.id = table_DELETE_MultipleTable_Join_1193.id ) LEFT OUTER JOIN ( delete_tbtest_part_02 PARTITION (p0) AS table_DELETE_MultipleTable_Join_1194 USE INDEX FOR JOIN () IGNORE INDEX FOR JOIN (idx_uni,idx_n,idx_f,idx_d) ,delete_tbtest_no_part_02 USE KEY FOR JOIN (idx_n) USE INDEX FOR GROUP BY () ) ON table_DELETE_MultipleTable_Join_1193.id = table_DELETE_MultipleTable_Join_1194.id WHERE ( delete_tbtest_no_part.tinyint_field =( (delete_tbtest_no_part.id) << ((select 1 from detele_tbtest_part_2 where id = 1)) ) OR delete_tbtest_no_part.char_field =( (select 'abcdefg' from detele_tbtest_part_2 where id = 1) ) OR delete_tbtest_no_part.timestamp_field = ((DATE_ADD(SYSDATE(),INTERVAL 1 DAY)) + INTERVAL (-1) MONTH ) ) AND delete_tbtest_no_part.id = 0 OR (delete_tbtest_no_part.id=47347 or delete_tbtest_no_part.id=47447 or delete_tbtest_no_part.id=47547 or delete_tbtest_no_part.id=47647) AND (table_DELETE_MultipleTable_Join_1192.id=47347 or table_DELETE_MultipleTable_Join_1192.id=47447 or table_DELETE_MultipleTable_Join_1192.id=47547 or table_DELETE_MultipleTable_Join_1192.id=47647) AND (table_DELETE_MultipleTable_Join_1193.id=47347 or table_DELETE_MultipleTable_Join_1193.id=47447 or table_DELETE_MultipleTable_Join_1193.id=47547 or table_DELETE_MultipleTable_Join_1193.id=47647) AND (table_DELETE_MultipleTable_Join_1194.id=47347 or table_DELETE_MultipleTable_Join_1194.id=47447 or table_DELETE_MultipleTable_Join_1194.id=47547 or table_DELETE_MultipleTable_Join_1194.id=47647) AND (delete_tbtest_no_part_02.id=47347 or delete_tbtest_no_part_02.id=47447 or delete_tbtest_no_part_02.id=47547 or delete_tbtest_no_part_02.id=47647) ;