Skip to main content

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.

More lessons in Indexes