Run EXPLAIN on a query selecting all fiction books — see the plan the planner chooses.

Answer

EXPLAIN SELECT * FROM books WHERE genre = 'fiction';