Clustered vs Secondary Index
Learn Clustered vs Secondary Index (Indexes, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction In InnoDB the table is its clustered index : a B+Tree on the primary key whose leaf pages contain the full rows. A secondary index is another B+Tree whose leaves hold the indexed columns plus the primary-key value, not a row address.