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.