Slide 18
Slide 18 text
InnoDB Indexes - Secondary
● Secondary index B-
tree leaf nodes
contain, for each key
value, the primary
keys of the
corresponding rows,
used to access
clustering index to
obtain the data
clustered
(primary key)
index
clustered
(primary key)
index
Secondary index
PK values
PK values
PK values
PK values
001
001
001
001 -
-
-
- nnn
nnn
nnn
nnn
B-tree leaf nodes, containing data
key values
key values
key values
key values
A Z
A Z
A Z
A Z
B-tree leaf nodes, containing PKs
Secondary index
key values
key values
key values
key values
A Z
A Z
A Z
A Z
B-tree leaf nodes, containing PKs
Secondary Index