Re: is my SELECT speed normal?
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.
Subject
Views
Written By
Posted
2210
June 27, 2012 01:09AM
Re: is my SELECT speed normal?
967
June 27, 2012 03:11AM
982
June 27, 2012 03:53AM
946
June 27, 2012 04:34AM
1033
June 27, 2012 11:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.