Delete Records of Delta Table (A&D)

3125
10
Jump to solution
06-14-2017 02:36 AM
PhuNguyen
New Contributor III

Hello,

Can i delete records of Delta table (A & D) in SQL Enterprise Geodatabase using SQL?

Thanks.

0 Kudos
10 Replies
Asrujit_SenGupta
MVP Regular Contributor

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.