Hello,
Can i delete records of Delta table (A & D) in SQL Enterprise Geodatabase using SQL?
Thanks.
Solved! Go to Solution.
This is called a Partial Compress and can be expected in multiple scenarios:
1. There are editors editing when you ran the compress
2. Because of Orphaned connections
3. ArcGIS Server services are running
Geodatabase compression—Help | ArcGIS Desktop
In a fully compressed geodatabase, there are no rows in the delta tables and the state tree is trimmed back to zero. Performance improvement is greatest if the geodatabase is fully compressed. To achieve this, do the following:
- Reconcile and post all outstanding changes in child versions to the DEFAULT version. As the geodatabase administrator, you can see in what order versions should be reconciled by default by opening the Reconcile Order subtab of the Versions tab on the Geodatabase Administration dialog box. See Version properties for information on the Reconcile Order subtab.
- Delete the versions themselves after you have reconciled and posted edits.
- Make sure no user is connected.
- Perform the compression operation.
So try these steps and then let us know if there are still records left in the Delta Tables after the Compress operation.