Question: what are the differences among primary secondary and clustering indexes?
Answer: DBMS - Indexing. We know that data is stored in the form of records. ... 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. Clustering Index − Clustering index is defined on an ordered data file.