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

CREATE INDEX syntax

Which command correctly creates an index on the tytul column in the ksiazki table?

Answer options

  • CREATE INDEX ksiazki ON idx_tytul(tytul);
  • ADD INDEX tytul TO ksiazki;
  • CREATE INDEX idx_tytul ON ksiazki(tytul);
  • INDEX ksiazki(tytul) CREATE;

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