spatial index(geo)とindex(geo) using rtreeの違い
mysql> show create table point¥G | |
Create Table: CREATE TABLE `point` ( | |
`id` bigint(20) NOT NULL AUTO_INCREMENT, | |
`spa` geometry NOT NULL, | |
`rtr` geometry NOT NULL, | |
PRIMARY KEY (`id`), | |
SPATIAL KEY `spa` (`spa`), | |
SPATIAL KEY `rtr` (`rtr`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment