must primary index be done over the primary key column? can the primary index be done on a column having duplicates?

I searched the textbook but I found it not that clear?

  • What's "primary index", if not primary key?
    – mustaccio
    Commented Mar 14, 2022 at 17:43
  • Which database system(s) does your textbook generally reference/ are you learning about?...as that'll affect the answer potentially. If by primary index you mean the clustered index, then in some database systems, it doesn't have to be clustered on the primary key and therefore doesn't need to be unique but again that would depend on the database system being discussed.
    – J.D.
    Commented Mar 14, 2022 at 22:20


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.