laptop and a wrench

Bug

Performing spatial joins on SDO_Geometry data using the Table Of Contents (TOC) causes poor performance compared to using the Spatial Join geoprocessing (GP) tool.

Last Published: September 8, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000101769
SubmittedDecember 28, 2016
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.2.2
StatusWill Not Be Addressed

Additional Information

Oracle 11g optimizer is using incorrect execution plan for the specific logfile table query. The same query in the trace shows different execution plans at 11g. Please re-test on Oracle 11g using shared logfile configurations without gathering statistics on logfile tables, or use Oracle 12c.

Steps to Reproduce

Bug ID: BUG-000101769

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