A full table scan occurs when the initial spatial cursor plan results in a full table scan, which impacts all future executions of the cursor.
上次发布: August 25, 2014No Product Found
漏洞 ID 编号
NIM049383
已提交
October 2, 2009
上次修改时间
April 28, 2025
适用范围
No Product Found
找到的版本
9.3.1
修正版本
9.3.1
状态
Fixed
此漏洞已得到修复。 有关详细信息,请参阅“版本修复”和“其他信息”(如果适用)。
附加信息
Fixed in 9.3.1 SP1 & 10.0 SP1 - If unable to upgrade please follow KB38019.
解决办法
Development has built into the ArcSDE that the spatial index on ST_Geometry feature classes is used AT ALL QUERIES from 9.3.1 SP2 and 10 SP1 forward. If your customer cannot move to 9.3.1 SP2 or 10.0 SP1 then they will need to follow the steps in the KB38019.HowTo: Disassociate the st_domain_operators from the st_domain_stats type in Oraclehttp://resources.arcgis.com/content/kbase?fa=articleShow&d=38019If your customer follows the instructions in KB article, then the spatial index will be used when zoomed in (and performance should/better be acceptable or something else is impacting performance).