Best Practices to tune up T-SQL and SP

Drew Rhoades

0/5 (0 vote)

Mar 2, 2012

CPOL

16391

I can't imagine that a correlated subquery is your best answer here:SELECT name FROM teacher WHERE EXISTS (SELECT 1 FROM student WHERE teacher.teacher_id = student.teacher_id)Instead, how about an INNER JOIN?SELECT DISTINCT teacher.nameFROM teacher INNER JOIN student ...

SELECT name FROM teacher WHERE EXISTS (SELECT 1 FROM student WHERE teacher.teacher_id = student.teacher_id)

SELECT DISTINCT teacher.name
FROM teacher
    INNER JOIN student
        ON teacher.teacher_id = student.teacher_id