What’s Faster? COUNT(*) or COUNT(1)?

(lukaseder) One of the biggest and undead myths in SQL is that COUNT(*) is faster than COUNT(1). Or was it that COUNT(1) is faster than COUNT(*)? Impossible to remember, because there’s really no reason at all why one should be faster than the other.

Register to Read