4. Database Indexing
Understand how indexing helps databases locate records quickly.
Ms Li wants to search for the record of Nina
Index Table
| Name | Pointer |
|---|---|
| Kevin | 4 |
| Aaron | 12 |
| Nina | 1 |
| Fiona | 15 |
| Oscar | 6 |
| Bella | 9 |
| Mason | 13 |
| Daisy | 2 |
| Ivan | 11 |
| Calvin | 7 |
| Luna | 5 |
| Gavin | 14 |
| Jenna | 3 |
| Ethan | 10 |
| Holly | 8 |