Bogue
Performance issue when using ArcSDE layers that do not have a registered ROWID column.
| Numéro d’ID de bogue | NIM044899 |
|---|---|
| Envoi | April 30, 2009 |
| Dernière modification | April 2, 2025 |
| S’applique à | ArcSDE/Enterprise Geodatabase |
| Version trouvée | 9.3 |
| Système d’exploitation | Windows OS |
| Version du système d’exploitation | 2003 |
| Statut | Known Limit |
Informations supplémentaires
No Public ExplanationSolution de contournement
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.Étapes pour reproduire
ID de bogue: NIM044899
Logiciel:
- ArcSDE/Enterprise Geodatabase
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support