laptop and a wrench

Bogue

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

Dernière publication: January 25, 2019 ArcSDE/Enterprise Geodatabase
Numéro d’ID de bogue BUG-000118916
EnvoiDecember 18, 2018
Dernière modificationJune 5, 2024
S’applique àArcSDE/Enterprise Geodatabase
Version trouvée10.5.1
Système d’exploitationWindows OS
Version du système d’exploitation7.0 64 Bit
StatutWill Not Be Addressed

Informations supplémentaires

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.

Solution de contournement

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.

Étapes pour reproduire

ID de bogue: BUG-000118916

Logiciel:

  • ArcSDE/Enterprise Geodatabase

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement