Question

Difference between primary index and secondary index in dbms

Answer 1

Answer:

A Secondary index is an index that is not a primary index and may have duplicates. eg. The primary index contains the key fields of the table. The primary index is automatically created in the database when the table is activated.

Answer 2

Answer:

☑ 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.