Mysql 8.0 OCP认证考试原题题库整理-第3题（CUUG内部资料）

3、Choose the best answer.

Examine this statement, which executes successfully:

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?

A) ALTER TABLE world.city ADD INDEX (Name) ;

B) ALTER TABLE world.city ADD SPATIAL INDEX (Name) ;

C) ALTER TABLE world.city ADD FULLTEXT INDEX (Name) ;

D) ALTER TABLE world.city ADD FULLTEXT INDEX (Population) ;

E) ALTER TABLE world.city ADD SPATIAL INDEX (Population) ;

F) ALTER TABLE world.city ADD INDEX (Population) ;