laptop and a wrench

Bug

Slow performance on field calculation when statistics exist in delta tables.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM045623
SubmittedMay 29, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3.1
StatusWill Not Be Addressed

Additional Information

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Workaround

Using multiversioned view to update the attributesThe tests results showed that, using multiversioned view, the same updating process finished within 2 minutes on ST_Geoemtry and 1 minute on SDEBINARY, no matter if statistics exist or not. The trace files for updating the attributes using multiversioned view were attached.

Steps to Reproduce

Bug ID: NIM045623

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options