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

Composite index

What is a composite (multi-column) index?

Answer options

  • An index that can only be created on the primary key
  • An index that automatically removes duplicates
  • An index stored in a separate database
  • An index built on several columns at once - it speeds up queries that filter by those columns together

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