我有一个SQL查询似乎产生了正确的结果，但根据EXPLAIN没有使用空间索引，因此返回所有行所花费的时间比必要的时间长得多。SELECT*FROMlistings2WHEREMBRContains(GeomFromText('POLYGON((32.653132834095-117.40548330929,32.653132834095-117.06151669071,32.942267165905-117.06151669071,32.942267165905-117.40548330929,32.653132834095-117.40548330929))'),geoPoint)=

我有以下多边形(在图像中你可以看到它覆盖的区域)POLYGON((-74.051004485022024.7239278424321,-74.050929383168984.7241416902206,-74.048306182752014.7237460717602,-74.046436683069034.7234306460692,-74.046356887351014.7234105978214,-74.046365269254014.7233310730989,-74.0461912609444.72327293317,-74.045790270695994.723200759