A field or fields in a record that dictate the sequence of the file. For example, the sort keys STATE and NAME arrange the file alphabetically by name within state. STATE is the major sort key, and ...

A field in a record that holds unique data which identifies that record from all the other records in the file or database. Account number, product code and customer name are typical key fields. As an ...