MySQL spatial data indexing performance comparison

Will the query of the MBR function against an indexed column with a geometry type containing points and polygons (GeomCollection type) be slower than the MBR function against an indexed column with a polygon type?

My programmer instincts tell me that it will be slower and I have to use the most descriptive spatial type that I can.

Edit: after reading Denis answer, the real question is:

In MySQL, "Is an indexed column with a geometry type that contains points and polygons actually contains the latter, or comes down to MBR?"

+3
source share
1 answer

, MySQL...

Postgres , GIST, , MBR, , , ..

, : " , , MBR?"

+1

All Articles