laptop and a wrench

漏洞

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

上次发布: January 25, 2019 ArcSDE/Enterprise Geodatabase
漏洞 ID 编号 BUG-000118916
已提交December 18, 2018
上次修改时间June 5, 2024
适用范围ArcSDE/Enterprise Geodatabase
找到的版本10.5.1
操作系统Windows OS
操作系统版本7.0 64 Bit
状态Will Not Be Addressed

附加信息

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.

解决办法

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.

重现步骤

漏洞 ID: BUG-000118916

软件:

  • ArcSDE/Enterprise Geodatabase

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项