Put in order · SQL and MySQL course · Module 9: Indexes and normalization

Kinds of indexes and their constraints

Arrange the three kinds of indexes from the strongest to the weakest constraint (from the strictest uniqueness control to none):

Items to put in order

  • UNIQUE INDEX (unique, allows NULL, can be many)
  • Plain INDEX (allows duplicates, only speeds things up)
  • PRIMARY KEY (unique, one per table, no NULL)

You can check the correct answer by solving this task in the CodeWorlds game.