I've always believed count(1) was faster as it doesn't have to return all columns just the row identity. But logically speaking the optimiser should take care of that so they should translate into the same underlying code

  12kissmi   answered on：Apr 16, 2009  0 comments

count (1) is faster than count(*) because count(*) returns all the rows as given in the select stmt including duplicate and null values while count(1) or count(expr) will return all non-null values in column 1.

  d4rkne5s   answered on：Apr 17, 2009  0 comments

count(1) will be faster than count(*) because it counts the first column values with not null

  b0n3less   answered on：Apr 18, 2009  0 comments

count(1) is faster than count(*)

  jasa   answered on：Apr 19, 2009  0 comments