Slide 24
Slide 24 text
https://speakerdeck.com/peterg/logical-database
Primary key (B-Tree index) on an
identity column
-∞ ↧ 367, '-∞' ↧ 733, '-∞' ↧ +∞
1, '(0,1)' 2, '(0,2)' ... 366, '(5,61)' 367, '-∞'
366 non-pivot items & high key
367, '(6,1)' 368, '(6,2)' ... 732, '(11,61)' 733, '-∞'
366 non-pivot items & high key
733, '(12,1)' 734, '(12,2)' ... +∞
2+ non-pivot items, implicit +∞ high key