We are working in ArcSDE 10.7 SQL server and when we run a full compress on a database with versioned feature classes, we do not see all the records in the Default table when we query these FC (tables) with a SDE view or in SQL Server. It looks like they stay in the Delta tables.
Is there a way to force in a full compress to write these Delta records to Default (Base Tables)?
Take a look at this blog; https://community.esri.com/groups/technical-support/blog/2015/03/24/tips-for-compressing-with-existi...
There are usually reasons for the compress not "flushing out" the delta tables.
Do you have replicas?
Are you reconciling all the versions after posting edits?
This gets them all looking at the same state