Which index does InnoDB use to physically store the table rows?
- A The clustered index (primary key)
- B Any secondary index
- C The first index created
- D A hash index
Answer
The clustered index (primary key)
InnoDB stores the full row in the leaves of the clustered index. Secondary indexes store the indexed columns plus the primary key value.





