NOT IN vs NOT EXISTS — One Can Return Wrong Results

WHERE Id NOT IN (SELECT UserId FROM BannedUsers)

If subquery returns NULL, results are wrong.

WHERE NOT EXISTS (
  SELECT 1 FROM BannedUsers b WHERE b.UserId = u.Id
)

SQL “DELETE Is Slow” — Use Batch Deletes

Post Views: 5