Performance issue when using ArcSDE layers that do not have a registered ROWID column.
上次发布: August 25, 2014ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
NIM044899
已提交
April 30, 2009
上次修改时间
April 2, 2025
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
9.3
操作系统
Windows OS
操作系统版本
2003
状态
Known Limit
经开发团队审核,已确定此问题与不受 Esri 控制的软件的已知限制有关。 问题的“其他信息”部分可能包含进一步说明。
附加信息
No Public Explanation
解决办法
The problem is with having sde layers without registered unique rowid column. When registering with the geodatabase then the objectid column is created as unique rowid column.If the user (for some reason) doesn't want to register with the geodatabase, then they can provide a unique column and register with ArcSDE using the sdetable command (sdetable -o register -c <rowid_column> ....).The selections sets need a unique column to select on. If there is no registered rowid column then the FID is used (and joins the business and F table). This is causing the slow performance.The resolution to the bug is to register the column.