Examine this statement, which executes successfully:
//IMG//
You want to improve the performance of this query:
//IMG//
Which change enables the query to succeed while accessing fewer rows?
- A.ALTER TABLE world.city ADD SPATIAL INDEX (Name);
- B.ALTER TABLE world.city ADD SPATIAL INDEX (Population);
- C.ALTER TABLE world.city ADD INDEX (Population);
- D.ALTER TABLE world.city ADD INDEX (Name);
- E.ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
- F.ALTER TABLE world.city ADD FULLTEXT INDEX (Population);