laptop and a wrench

Bug

Performance issue when using ArcSDE layers that do not have a registered ROWID column.

Zuletzt veröffentlicht: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer NIM044899
EingereichtApril 30, 2009
Zuletzt geändertApril 2, 2025
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version9.3
BetriebssystemWindows OS
Betriebssystemversion2003
StatusKnown Limit

Zusätzliche Informationen

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.

Schritte zur Reproduzierung

Bug-ID: NIM044899

Software:

  • ArcSDE/Enterprise Geodatabase

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln