The table used in this demonstration is a simple three-column customer table, defined as follows.
| Column Name | Attribute Described | Type of Index Defined on the Column |
|---|---|---|
| Cust | Customer Number | USI |
| Name | Customer Last Name | NUSI |
| Phone | Customer Phone Number | NUPI |
The following is a snapshot instance of this table.
| Customer | ||
|---|---|---|
| Cust | Name | Phone |
| USI | NUSI | NUPI |
| 37 | White | 555-4444 |
| 98 | Brown | 333-9999 |
| 74 | Smith | 555-6666 |
| 95 | Peters | 555-7777 |
| 27 | Jones | 222-8888 |
| 56 | Smith | 555-7777 |
| 45 | Adams | 444-6666 |
| 31 | Adams | 111-2222 |
| 40 | Smith | 222-3333 |
| 72 | Adams | 666-7777 |
| 84 | Rice | 666-5555 |
| 49 | Smith | 111-6666 |
| 12 | Young | 777-7777 |
| 62 | Black | 444-5555 |
| 77 | Jones | 777-6666 |
| 51 | Marsh | 888-2222 |
Base table and secondary index subtable rows are distributed as illustrated by the following graphic.