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

Index on the primary key

Which index does every table have from the very start?

Answer options

  • An index on the primary key (PRIMARY KEY), usually on the id column
  • An index on every text column
  • An index on the most recently added column
  • None - indexes must always be created manually

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