You don’t need numbers when you only need truth. IF EXISTS ( SELECT 1 FROM Orders WHERE CustomerId = 42 ) BEGIN PRINT ‘Has orders’ END Why it’s faster Stops at the first match Avoids full scans Reduces CPU usage