Community

Can COUNT(*) be used in MySQL on InnoDB tables?

(Thomas) COUNT() function returns a number of rows returned by a query. In a popular opinion COUNT(*) should not be used on InnoDB tables, but this is only half true.

Read More - Register for Free Membership