[nycphp-talk] Re: MySQL doubt

Faber Fedor faber at
Fri Jan 14 00:36:48 EST 2005

On 14/01/05 10:53 +0530, Sajith A wrote:
> I'm not sure whether i should post this here. Correct me if i'm
> wrong.. I would like to know
> whether there is any performance difference between. "SELECT count(*)
> FROM table" and "SELECT count(field) FROM table".

Depends on the table. Read 
then do

EXPLAIN SELECT count(*) FROM table;

EXPLAIN SELECT count(field) from table;

at the mysql prompt and let us know what you find.


Linux New Jersey: Open Source Solutions for New Jersey

More information about the talk mailing list