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.