Question: what is the difference between clustered index and secondary index?
Answer: Primary index: in a sequentially ordered file, the index whose search key specifies the sequential order of the file. Also called clustering index. ... Secondary index: an index whose search key specifies an order different from the sequential order of the file. Also called non-clustering index.