Count(*) picks all the rows on the table while performing count where as count(1) just takes rowID to perform count which is obviously quick. Some one else may elaborate more !