SQL count(1) is not better than count(*)

Apr

jameswiseman Programming 2010-04-14

The use of

select count(1) from mytable

instead of

select count(*) from mytable

is shrounded in rumour, myth and folklore.

Well, fortunately, Majita Lah at MI Lambda has taken the time to dispel this:

What’s Wrong with Count: http://milambda.blogspot.com/2008/01/whats-wrong-with-count.html

James Wiseman