4 ms·

correlated subqueries are faster than joins on SQL Server too.

• trezor 17y ago
  Is this also true when the query would involve a full table scan or clustered index scan anyway? Maybe I'm missing something crucial, but that doesn't seem to make much sense for me from a data-access perspective.