Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第3题
3、Choose the best answer.Examine this statement, which executes successfully:http://www.cuug.com.cn/uploadfile/2020-12/26375285312.jpgYou want to improve the performance of this query:SELECT NameFROM world.cityWHERE 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) ;
页:
[1]