Key Terminology
Index key field
- Not necessarily the same as the primary DB key of the table!
But called a “key” anyway
Primary index
- Key is the primary (DB) key
- Only one index per file
Secondary index
- Key is not the primary DB key
- Could be many indices per file (or none)