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

When to add an index

Which columns are most worth indexing?

Answer options

  • All columns without exception - the more indexes, the better
  • Only columns storing long description texts
  • Those that often appear in WHERE, JOIN or ORDER BY
  • Columns we never use in queries

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