Question: what is the difference between a primary index and a secondary index?
Answer: Difference Between Primary Index and Secondary Index A primary index is an index on a set of fields that includes the unique primary key and is guaranteed not to contain duplicates. In contrast, a secondary index is an index that is not a primary index and may have duplicates.