Question

Differentiate between
primary and index

Answer 1

hey,

Primary Index − Primary index is defined on an ordered data file. The data file is ordered on a key field. Secondary Index − Secondary index may be generated from a field which is a candidate key and has a unique value in every record, or a non-key with duplicate values.