Examine this statement, which executes successfully:
You want to improve the performance of this query:
Which change enables the query to succeed while accessing fewer rows?
ALTER TABLE world.city ADD SPATIAL INDEX (Name);
ALTER TABLE world.city ADD SPATIAL INDEX (Population);
ALTER TABLE world.city ADD INDEX (Population);
ALTER TABLE world.city ADD INDEX (Name);
ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
Submit