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?
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);
SPATIAL INDEX creates an R-tree index. For storage engines that support nonspatial indexing of spatial columns, the engine creates a B-tree index. A B-tree index on spatial values is useful for exact-value lookups, but not for range scans.
The optimizer can use spatial indexes defined on columns that are SRID-restricted.
So answer is B.
Correct answer should be C . You can't add a spartial index on non-geo data types
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
LrnsTgh
7 months agonkanike1
10 months, 1 week agoMohindar
1 year, 1 month agoHSong
1 year, 2 months agofthusa
1 year, 3 months agoRicoAndriol
1 year, 4 months agoNelate
1 year, 5 months ago