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 Support アプリのダウンロード

このトピックについてさらに調べる

ArcGIS エキスパートのサポートを受ける

テクニカル サポートへのお問い合わせ

Esri Support アプリのダウンロード

ダウンロード オプションに移動