BUG-000096827 for ArcSDE/Enterprise Geodatabase

漏洞 ID 编号	BUG-000096827
已提交	June 1, 2016
上次修改时间	June 5, 2024
适用范围	ArcSDE/Enterprise Geodatabase
找到的版本	10.2.2
状态	Known Limit

附加信息

This is just how the fully qualified _f functions work. In order to get better performance with the query, you should be able to use a pl/sql cursor or a ref cursor object to run the sql with the sde.st_intersects operator (select id from table1 t1, table2 t2 where sde.st_intersects (t1.shape,t2.shape) = 1) rather than use the package function (sde.st_relation_function.st_intersects_f). This will then use the domain index and run much faster.

重现步骤

漏洞 ID: BUG-000096827

软件:

ArcSDE/Enterprise Geodatabase

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

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项

In some scenarios, the performance is much slower when using the fully qualified name for certain SQL functions.

附加信息

重现步骤

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

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