COUNT(*) vs COUNT(1): Which One Performs Best?
When counting rows in a table, we reach for the count function out of habit. But the count function accepts several kinds of arguments, such as count(1), count(*), count(field), and so on. So which form of count delivers the best performance?
9 minDatabase Internals
