Secondary Indexes

A Secondary Index is an ordered file with two fields. The first is of the same data type as some nonordering field and the second is either a block or a record pointer.

If the entries in this nonordering field must be unique this field is sometime referred to as a Secondary Key.