MySQL8.0 OCP最新版1Z0-908认证考试题库整理-003

原题

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) ;

解析

Answer：F 分析： mysql> ALTER TABLE city ADD SPATIAL INDEX(Population); ERROR 1687 (42000): A SPATIAL index may only contain a geometrical type column

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！