Figure 3: Non-clustered index (with no clustered index)
-----------------------------------------------------------------------------
| Root Node |
| 6 |
| ---------- |
| |Adam 7| |
| |--------| |
| |Sally 8| |
| |--------| |
| | | |
| |--------| |
| | | |
| ---------- |
| |
| Intermediate Level Pages |
| 7 8 |
| ---------- ---------- |
| |Adam 9| |Sally 13| |
| |--------| |--------| |
| |Ed 10| | | |
| |--------| |--------| |
| |Jill 11| | | |
| |--------| |--------| |
| |Ned 12| | | |
| ---------- ---------- |
| |
| Leaf Level |
| 9 10 11 12 13 |
| ----------- ----------- ----------- ----------- ----------- |
| |Adam 5.3| |Ed 3.4| |Jill 3.2| |Ned 1.2 | |Sally 2.4| |
| |---------| |---------| |---------| |---------| |---------| |
| |Bill 3.1| |Frank 5.2| |Karen 4.2| |Oscar 2.2| |Ted 4.1| |
| |---------| |---------| |---------| |---------| |---------| |
| |Chris 1.4| |Greg 2.1| |Linda 4.1| |Peter 4.4| |Vito 1.1| |
| |---------| |---------| |---------| |---------| |---------| |
| |Dawn 4.3| |Harry 5.4| |Mary 2.3| |Ralph 1.3| |Willy 3.3| |
| ----------- ----------- ----------- ----------- ----------- |
| |
| Data Pages |
| 1 2 3 4 5 |
| ----------- ----------- ----------- ----------- ----------- |
| |Vito | |Greg | |Bill | |Ted | |Linda | |
| |---------| |---------| |---------| |---------| |---------| |
| |Ned | |Oscar | |Jill | |Karen | |Frank | |
| |---------| |---------| |---------| |---------| |---------| |
| |Ralph | |Mary | |Willy | |Dawn | |Adam | |
| |---------| |---------| |---------| |---------| |---------| |
| |Chris | |Sally | |Ed | |Peter | |Harry | |
| ----------- ----------- ----------- ----------- ----------- |
| |
|---------------------------------------------------------------------------|
|