CREATE TABLE world.city (

ID int NOT NULL AUTO INCREMENT,

Name char(35) NOT NULL DEFAULT ",

CountryCode char(3) NOT NULL DEFAULT ",

District char(20) NOT NULL DEFAULT ",

Population int NOT NULL DEFAULT '0',

PRIMARY KEY (ID),

KEY CountryCode (CountryCode)

) ENGINE=InnoDB;

You want to improve the performance of this query:

SELECT Name

FROM world.city

WHERE Population BETWEEN 1000000 AND 2000000;

Which change enables the query to succeed while accessing fewer rows?