Subquery vs JOIN
Sometimes JOIN is faster than subquery.
Example
Slower (subquery):
SELECT * FROM students
WHERE id IN (SELECT student_id FROM enrollments);Faster (JOIN):
SELECT DISTINCT students.*
FROM students
JOIN enrollments ON students.id = enrollments.student_id;Summary
Try JOIN instead of subquery Test both to see which is faster