in 与exists区别
– 慢
SELECT *
FROM Class_A
WHERE id IN (SELECT id
FROM CLASS_B);
– 快
SELECT *
FROM Class_A A
WHERE EXISTS
(SELECT *
FROM Class_B B
WHERE A.id = B.id);
in 与exists区别
– 慢
SELECT *
FROM Class_A
WHERE id IN (SELECT id
FROM CLASS_B);
– 快
SELECT *
FROM Class_A A
WHERE EXISTS
(SELECT *
FROM Class_B B
WHERE A.id = B.id);