Related Documentation Download this Manual
PDF (US Ltr) - 38.4Mb
PDF (A4) - 38.4Mb
PDF (RPM) - 37.7Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 9.0Mb
Man Pages (TGZ) - 197.6Kb
Man Pages (Zip) - 306.1Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

how-to-avoid-table-scan

This page has moved or been replaced. The new page is located here:

http://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html

Please update any bookmarks that point to the old page.


User Comments
  Posted by Becky D on February 28, 2011
We ran into a condition where we were trying to join on 2 varchar fields that used a different collation. One field was utf-8 and the other was latin1. This was causing a full table scan on a join between the 2 tables. Once we converted the fields to all be utf-8, query went from 9 seconds down to 0.
Sign Up Login You must be logged in to post a comment.