Movatterモバイル変換

ForMyISAM andInnoDB tables, search operations in columns containing spatial data can be optimized usingSPATIAL indexes. The most typical operations are:

MySQL usesR-Trees with quadratic splitting forSPATIAL indexes on spatial columns. ASPATIAL index is built using the minimum bounding rectangle (MBR) of a geometry. For most geometries, the MBR is a minimum rectangle that surrounds the geometries. For a horizontal or a vertical linestring, the MBR is a rectangle degenerated into the linestring. For a point, the MBR is a rectangle degenerated into the point.

It is also possible to create normal indexes on spatial columns. In a non-SPATIAL index, you must declare a prefix for any spatial column except forPOINT columns.

MyISAM andInnoDB support bothSPATIAL and non-SPATIAL indexes. Other storage engines support non-SPATIAL indexes, as described inSection 15.1.15, “CREATE INDEX Statement”.