I can't find a nice reference that says this. I remember one day I had a big count on MySQL, and I tried this (COUNT(*) vs COUNT(id)) and it made no difference at all. I found this link too: http://stackoverflow.com/questions/2710621/count-vs-count1-vs-countpk-which-is-better