laptop and a wrench

Bug

The 'sde.st_within(sde.ST_centroid(a.shape),b.shape) = 1' query executes only with a full table scan causing it to run extremely slow.

Last Published: August 31, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM091870
SubmittedMay 22, 2013
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.0
StatusWill Not Be Addressed

Additional Information

Inline SQL operator such as st_centroid requires a full table scan.

Steps to Reproduce

Bug ID: NIM091870

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options