You followed the rules. You created indexes. You wrote a simple query. And yet MySQL still scanned the entire table. Imagine this. You have just learned about indexes in MySQL. You are feeling ...