delete的不同写法会导致性能差:
1. 下面的语句,如果tbl_message的数据很多, delete操作会很慢, 因为下面的写法会导致索引失效
DELETE FROM tbl_message WHERE user_id in (select id from tbl_user where cmp_id = 'f9afd00')
解决方法: 下面的写法的索引是生效的
DELETE a.* FROM tbl_message a inner join tbl_user b on b.id=a.user_id WHERE b.cmp_id = 'f9afd00'
2. select in 查询的in是会走索引的
SELECT * FROM tbl_message WHERE user_id in (select id from tbl_user where cmp_id = 'f9afd00')