laptop and a wrench

Bug

In some scenarios, the performance is much slower when using the fully qualified name for certain SQL functions.

Last Published: January 6, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000096827
SubmittedJune 1, 2016
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.2.2
StatusKnown Limit

Additional Information

This is just how the fully qualified _f functions work. In order to get better performance with the query, you should be able to use a pl/sql cursor or a ref cursor object to run the sql with the sde.st_intersects operator (select id from table1 t1, table2 t2 where sde.st_intersects (t1.shape,t2.shape) = 1) rather than use the package function (sde.st_relation_function.st_intersects_f). This will then use the domain index and run much faster.

Steps to Reproduce

Bug ID: BUG-000096827

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