Slower performance encountered for particular feature classes after editing

Description

After multiple edit sessions, an ArcSDE feature class performance degrades.

Cause

Performance is impacted when the edits of a versioned ArcSDE feature class or table accumulate and are not moved to the base table.

Registering a feature class or table as versioned creates delta tables (Adds and Deletes tables) in the database. When edits are made to the versioned feature class or table in ArcMap, the associated delta tables store the changes.

Over time, edits accumulate in the delta tables increasing the size of the database and slowing the performance.

Solution or Workaround