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.