I have a mysql table with multiple fields and the index is an auto_incremented int called id.
I was wondering if it's faster to do
SELECT COUNT(*) FROM mytable
or
SELECT COUNT(id) FROM mytable
The results are, of course, the same. Any insight into this would be appreciated. Thanks.
I was wondering if it's faster to do
SELECT COUNT(*) FROM mytable
or
SELECT COUNT(id) FROM mytable
The results are, of course, the same. Any insight into this would be appreciated. Thanks.