Logical Storage of Indexes
This section presents an overview of how the database server creates and fills an index.
Creation of Root and Leaf Nodes
Creation of branch nodes
Duplicate Key Values
Key-Value Locking
Adjacent Key Locking
Freed Index Pages
Filling Indexes
Calculating the Length of Index Items
Parent topic:
Structure of B-Tree Index Pages