Skip to main content

Full Table Scan vs Index Scan

Learn Full Table Scan vs Index Scan (Query Optimization, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A full table scan (EXPLAIN type ALL ) reads every row of the clustered index. An index scan reads index entries: ref/range seeks to matching entries, while type index reads the whole index (smaller than the table).

More lessons in Query Optimization