Computer Science, asked by Bipu3430, 9 months ago

Difference between primary index and secondary index in dbms

Answers

Answered by TonightGamer73
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.

Answered by Anonymous
0

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.

Similar questions