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.