Coding task · SQL and MySQL course · Module 9: Indexes and normalization

Index on a foreign key

The autor_id column in ksiazki links them to authors - one author has many books, so duplicates are normal here. A plain index speeds up joining tables.

Task

Create a plain index named idx_autor on the autor_id column in the ksiazki table.