Coding task · SQL and MySQL course · Module 9: Indexes and normalization
Composite index
When you often search for a specific author's books in a given category, an index on both columns at once will speed up such a query.
Task
Create a composite index named idx_autor_kat on the autor_id and kategoria_id columns in the ksiazki table.