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.