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.