When are spatial indexes used?

Spatial indexes are used with queries in Oracle and PostgreSQL that call functions to compare geometries. The Oracle and PostgreSQL ST_Geometry functions that use spatial indexes are the ones that test spatial relationships.

Additionally, the spatial column must appear immediately after the spatial relationship function in the query for the spatial index to be used.

TipTip:

For information on DB2 ST_Geometry functions that can use a spatial index, see the DB2 documentation.

See the IBM Informix Spatial DataBlade Module User's Guide for information on functions that utilize Informix's R-tree spatial index.

Spatial indexes are not used automatically with any ST_Geometry functions in SQLite.

Related Topics

6/19/2015