单选题

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?

AALTER TABLE world.city ADD INDEX (Name) ;

BALTER TABLE world.city ADD SPATIAL INDEX (Name) ;

CALTER TABLE world.city ADD FULLTEXT INDEX (Name) ;

DALTER TABLE world.city ADD FULLTEXT INDEX (Population) ;

EALTER TABLE world.city ADD SPATIAL INDEX (Population) ;

FALTER TABLE world.city ADD INDEX (Population) ;

查看答案

正确答案：A （备注：此答案有误）

相似试题

判断题

Employers often choose the best candidate.

答案解析
单选题

[音频]Listen to the dialogue and choose the best answer to the question you hear.( )

答案解析
单选题

Choose the best answer.Which statement is true about InnoDB persistent index statistics?

答案解析
单选题

Choose the best answer.How can mysqld_multi be configured to allow MySQL instances to use the same port number?

答案解析
单选题

Choose the best answer.Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

答案解析