ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

When are spatial indexes used with ST_Geometry?

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.

  • ST_Contains (PostgreSQL)
  • ST_Crosses
  • ST_Disjoint (PostgreSQL)
  • ST_Equals
  • ST_Intersects
  • ST_Overlaps
  • ST_Relate (Oracle)
  • ST_Touches
  • ST_Within

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

Tip:

For information on IBM Db2 ST_Geometry functions that can use a spatial index, see the Db2 spatial function documentation in the IBM Knowledge Center.

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

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

Related topics

  • Relational functions for ST_Geometry

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal