laptop and a wrench

Bug

Executing the Analyze Datasets tool disassociates statistics, ST_DOMAIN_STATS from ST_DOMAIN_OPERATORS, in Oracle geodatabases.

Last Published: July 20, 2017 ArcGIS for Desktop
Bug ID Number BUG-000099192
SubmittedSeptember 7, 2016
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.2.2
Operating SystemWindows OS
Operating System Version7
StatusWill Not Be Addressed

Additional Information

We want the st_domain_stats to be disassociated from the st_domain_operators due to the oracle optimizer costing the st_envIntersects function for a full table scan when the data is viewed first at full extent AND then caching the query plan so all subsequent queries in that session will use a full table scan (even when zoomed in where the spatial index should be used). See Oracle Support Document 1268383.1 at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1268383.1). Disassociating will make st_envIntersects always use the spatial index, thus improving the majority of pans and zooms. See: Esri Technical Article: http://support.esri.com/technical-article/000010992

Steps to Reproduce

Bug ID: BUG-000099192

Software:

  • ArcGIS for Desktop

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