laptop and a wrench

Bug

The ST_INTERSECTS query against versioned views does not use the spatial index on the base tables and so exhibits slow performance.

Zuletzt veröffentlicht: January 25, 2019 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer BUG-000118916
EingereichtDecember 18, 2018
Zuletzt geändertJune 5, 2024
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version10.5.1
BetriebssystemWindows OS
Betriebssystemversion7.0 64 Bit
StatusWill Not Be Addressed

Zusätzliche Informationen

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024 https://support.esri.com/en-us/products/arcmap/life-cycle. There are no plans to release an ArcGIS Desktop 10.9, and we recommend that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate for more information.

Workaround

Create a custom versioned view which incorporates st_geometry functions inside the view. The st_intersects query is added to the end WHERE clause in both sides of the UNION in the versioned view.  So this means the ST_INTERSECTS filter is added to the Adds and Base portion of the view DDL. Adding the function to the view DDL allows the spatial index to be used.

Schritte zur Reproduzierung

Bug-ID: BUG-000118916

Software:

  • ArcSDE/Enterprise Geodatabase

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln