MySQL 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第3题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询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) ;
本文地址：http://www.cuug.com.cn/mysql/mysql8/26305890083.html 转载请注明！
