Hi, select count(*) is very slow in innodb (because it is a table scan). Is there any difference if I change it to select count(column).
I did some test and some times select count(*) is really slow and some time select count(column) is slow. Could anyone help me? If I need do a select(*) in innodb, is there any way to get away from the slowness? In the sql, should we avoid doing select * or select count(*)? What is the reason? Thank you for your help! Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
