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