Question · SQL and MySQL course · Module 9: Indexes and normalization
Which column for a plain INDEX
Which column is the best fit for a plain INDEX (with duplicates)?
Answer options
- id in the ksiazki table - that is the primary key
- autor_id in the ksiazki table - one author has many books, so the values repeat
- email in the czytelnicy table - here uniqueness is needed
- No column is suitable for a plain INDEX
You can check the correct answer by solving this task in the CodeWorlds game.