st_intersects gets stuck on large amounts of features if they are without st_envintersects on RHEL 5.3.
上次发布: December 18, 2015ArcGIS Server (Java)
漏洞 ID 编号
NIM057453
已提交
May 18, 2010
上次修改时间
April 2, 2025
适用范围
ArcGIS Server (Java)
找到的版本
10.0
修正版本
10
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
解决办法
Add sde.st_EnvIntersect to the where filter: SELECT /*+ USE_NL(Z9_COORD SEC_POLY) */ Z9_COORD.ZIP5,Z9_COORD.ZIP4,'V' FROM SUBMIT_MST_ZIP9_COORD Z9_COORD,wadown.SUBMIT_WAP_SECTION_POLYGON SEC_POLY WHERE SDE.ST_EnvINTERSECTS(Z9_COORD.SHAPE,SEC_POLY.SHAPE) = 1 AND SDE.ST_INTERSECTS(Z9_COORD.SHAPE,SEC_POLY.SHAPE) = 1 AND z9_COORD.FACILITY_NBR = 191 AND SEC_POLY.FACILITY_NBR = 191 AND SEC_POLY.WORK_AREA_PLAN_ID = 265538 AND Z9_COORD.data_vendor_type = 'NTQ' AND Z9_COORD.GEOCODE_SCORE IN (0, 1, 2, 3, 5);