On 22 Jul 2003 at 9:30, gerald_clark wrote: > If you are using MYISAM tables, count(*) does not scan the table to > get the count.
That's only true if you have no WHERE clause and thus are counting all the rows in the table. That doesn't seem to be what the original poster is doing. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]