Question What is the correct workflow to achieve a full compress in a versioned geodatabase using replicas?
Answer To achieve a full compress in a versioned geodatabase (that is, move edits from the Adds and Deletes tables to the business tables, and remove unreferenced states), perform the following workflow:
Compressing the ArcSDE geodatabase pushes records from the Adds & Deletes tables to the base table. Over time, an actively edited geodatabase will accumulate unreferenced rows in its delta tables and a deep state tree, both of which can negatively impact performance. Occasionally, depending on the volume of edits, the ArcSDE administrator must compress the geodatabase to remove the unreferenced rows and reduce the depth of the state tree. Compressing never removes data that can be accessed through any version’s lineage and will not harm your geodatabase; it exclusively cleans up unused data.
If you are finding that there are still records in the A & D tables after running the SDE compress, please try the following steps Continue reading →