Best Practices to tune up T-SQL and SP

Drew Rhoades

Rate me:

0.00/5 (No votes)

2 Mar 2012CPOL

15.9K

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 ...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Drew Rhoades

Technical Lead PDI

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Best Practices to tune up T-SQL and SP

Alternatives

License

Comments and Discussions