NYCPHP Meetup

[nycphp-talk] Re: MySQL doubt

Faber Fedor faber at linuxnj.com
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 http://dev.mysql.com/doc/mysql/en/EXPLAIN.html 
then do

EXPLAIN SELECT count(*) FROM table;

EXPLAIN SELECT count(field) from table;

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

-- 
 
Regards,
 
Faber                     

Linux New Jersey: Open Source Solutions for New Jersey
http://www.linuxnj.com






More information about the talk mailing list