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?

Question

Exhibit

Options

• AALTER TABLE world.city ADD SPATIAL INDEX (Name);
• BALTER TABLE world.city ADD SPATIAL INDEX (Population);
• CALTER TABLE world.city ADD INDEX (Population);
• DALTER TABLE world.city ADD INDEX (Name);
• EALTER TABLE world.city ADD FULLTEXT INDEX (Name);
• FALTER TABLE world.city ADD FULLTEXT INDEX (Population);

• B
  83% (24)
• D
  10% (3)
• E
  3% (1)
• F
  3% (1)

Explanation

https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html

No community discussion yet for this question.