laptop and a wrench

Erro

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

Última Publicação: January 25, 2019 ArcSDE/Enterprise Geodatabase
Número de ID do Erro BUG-000118916
EnviadoDecember 18, 2018
Última ModificaçãoJune 5, 2024
Aplica-se àArcSDE/Enterprise Geodatabase
Versão encontrada10.5.1
Sistema OperacionalWindows OS
Versão do Sistema Operacional7.0 64 Bit
StatusWill Not Be Addressed

Informações Adicionais

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.

Solução Provisória

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.

Etapas para Reproduzir

ID do Erro: BUG-000118916

Software:

  • ArcSDE/Enterprise Geodatabase

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download