Full Table Scan / Sequential Scan in MySQL: Understanding when this happens with EXPLAIN statement and avoiding optimizer’s choice of incorrect table scan


Post @ http://singztechmusings.in/full-table-scan-sequential-scan-in-mysql-understanding-when-this-happens-with-explain-statement-and-avoiding-optimizers-choice-of-incorrect-table-scan/

About these ads

About this entry

You’re currently reading “Full Table Scan / Sequential Scan in MySQL: Understanding when this happens with EXPLAIN statement and avoiding optimizer’s choice of incorrect table scan,” an entry on Singaram's Tech Musings

Published:
January 11, 2012 / 11:22 PM
Category:
Database, MySQL, SQL
Tags:
, , , , , , ,