Executing the Analyze Datasets tool disassociates statistics, ST_DOMAIN_STATS from ST_DOMAIN_OPERATORS, in Oracle geodatabases.
上次发布: July 20, 2017ArcGIS for Desktop
漏洞 ID 编号
BUG-000099192
已提交
September 7, 2016
上次修改时间
June 5, 2024
适用范围
ArcGIS for Desktop
找到的版本
10.2.2
操作系统
Windows OS
操作系统版本
7
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
We want the st_domain_stats to be disassociated from the st_domain_operators due to the oracle optimizer costing the st_envIntersects function for a full table scan when the data is viewed first at full extent AND then caching the query plan so all subsequent queries in that session will use a full table scan (even when zoomed in where the spatial index should be used).
See Oracle Support Document 1268383.1 at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1268383.1).
Disassociating will make st_envIntersects always use the spatial index, thus improving the majority of pans and zooms. See: Esri Technical Article: http://support.esri.com/technical-article/000010992