Thanks to both Dans, that's it. This even discussed in the refman, at ( http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html).
In my case, COUNT(*) found 25,682,600 rows and it took about 7 minutes. Thanks, Mike
Thanks to both Dans, that's it. This even discussed in the refman, at ( http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html).
In my case, COUNT(*) found 25,682,600 rows and it took about 7 minutes. Thanks, Mike