Jamie Longstreet-481950 (2/6/2010)
it makes far more sense (to me) that an "exists" functionality will provide a faster and more efficient query than one searching the index for a value (IN statement).
It does indeed make more sense - and the SQLServer optimiser knows it too, which is why it treats both versions the same 🙂