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).