Question · SQL and MySQL course · Module 9: Indexes and normalization

Plain INDEX and duplicates

What sets a plain INDEX apart from PRIMARY KEY and UNIQUE?

Answer options

  • A plain INDEX does not speed up searching
  • A plain INDEX can only be one per table
  • A plain INDEX always blocks NULL values
  • A plain INDEX allows repeated values - it only speeds up searching, it does not enforce uniqueness

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