Why InnoDB Secondary Indexes Use the Primary Key as an Indirection?



This content originally appeared on Level Up Coding – Medium and was authored by Rahul Arora

How MySQL InnoDB uses the primary key as an indirection in secondary indexes and what it means for query performance.


This content originally appeared on Level Up Coding – Medium and was authored by Rahul Arora