Plurrrr

a tumblelog
23 Sep 2019

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

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. But is the myth justified?

Let’s measure!

Source: What’s Faster? COUNT(*) or COUNT(1)?.

Learn CSS by Playing Games

In the evening I played 3 games to practice my CSS:

Have fun!