Question: what is the difference between primary index secondary index and clustering index?
Answer: Primary Index − Primary index is defined on an ordered data file. ... 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.