[nycphp-talk] Re: MySQL doubt
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
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