Re: is my SELECT speed normal?

[Aftab Khan]

For *small tables, a *table scan often is appropriate and the performance impact is negligible. For large tables, it would impact performance a lot, you should avoid table scans.

http://dev.mysql.com/doc/refman/5.1/en/how-to-avoid-table-scan.html

*table scan e.g. SELECT * FROM table
*small tables - fewer than 10 rows and a short row length



Edited 1 time(s). Last edit at 06/27/2012 03:14AM by Aftab Khan.