>
>What I learned is that IN with a subquery is always very poor performance and should never be done. Always use Exists instead.
>
>
http://stackoverflow.com/questions/2065329/sql-server-in-vs-exists-performanceChristian, that line about "always very poor performance" is simply not true.
Yes, there are benefits to using EXISTS - but for almost the last 10 years, the optimizer often will generate the same plan. If you'd read that full stackoverflow article (and many others out there), you'd see there can be several factors.