NIM044899 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM044899
Submitted	April 30, 2009
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	9.3
Operating System	Windows OS
Operating System Version	2003
Status	Known Limit

Additional Information

No Public Explanation

Workaround

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.