SQL Server B-Tree: Page Split in a Nonclustered Index
StackOverflow dbo.Users — nonclustered index on Location
UPDATE
dbo.Users
SET
Location = 'Jakarta'
WHERE
Id = 26837;
Root
Level 3
Intermediate
Level 2
Intermediate
Level 1
Leaf · keys
Level 0
Root page 1:900
Aachen → 1:910
Madrid → 1:911
Seattle → 1:912
Intermediate page 1:910
Aachen → 1:920
Denver → 1:921
Kyoto → 1:922
⋯
Intermediate page 1:911
Madrid → …
…
Intermediate page 1:912
Seattle → …
…
⋯
Intermediate page 1:920
Aachen → …
…
Intermediate page 1:921
Denver → 1:930
Geneva → 1:931
Jakarta → 1:932
⋯
Kingston → 1:987
Intermediate page 1:922
Kyoto → …
…
⋯
Page 1:930
Denver · Id 19,406
Dublin · Id 4,588
Frankfurt · Id 33,072
⋯
Page 1:931
Geneva · Id 41,209
Hamburg · Id 8,114
Helsinki · Id 26,837
Helsinki · Id 590,442
Houston · Id 12,006
Istanbul · Id 77,351
Page 1:987 · new
Page 1:932
Jakarta · Id 11,208
Jakarta · Id 60,113
Johannesburg · Id 2,290
Kingston · Id 15,772
Kraków · Id 88,554
Kuala Lumpur · Id 7,036
Jakarta · Id 26,837