自己试一下最重要
a表有几十条索引,b表几条索引还有分区 a 表 728039 条 b表 8809883 条
(1)select count(1) from a a left join b b on a.id=b.id;----3.531 --3.188 --9284472
(2)select count(1) from a a left join b b on a.id=b.id; ----3.359 --1.609 --8809883
(3) select * from A as AA,B as BB where AA.id = BB.id ----3.062 --2.593 --8744249
(4) select * from A where id in (select id from B);--4.234 --3 --187816
(5) select * from B where id in (select id from A); --55.421 --2.657 --8744249
结果:
(1)select * 时长为3.531秒,count(1)时长为3.188 数据为9284472
(2)select * 时长为3.359秒,count(1)时长为1.609 数据为8809883
所以你还要根据你的业务来