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

Check the query plan

EXPLAIN reveals how the Library intends to find the scrolls - whether it will look in the catalog (an index) or walk shelf by shelf.

Task

Write a command that shows the execution plan of a query retrieving all columns from the ksiazki table where tytul is 'Iliada'. Use EXPLAIN.