We have a feature class in sde that is not compressing as expected.
- database Oracle
- ArcGIS version 10.6.1
My understanding is that if an A row edit state is not linked to a version it is eligible for compression. So, I have made up a SQL query to find said rows.
--versions that join to states
with lina as
(select s.lineage_name
from XXXX.a106 a
join sde.states s
on a.sde_state_id = s.state_id),
linv as
(select v.owner, v.name, s.lineage_name
from sde.versions v
join sde.states s
on v.state_id = s.state_id)
select linv.owner, linv.name, count(*) as a_row_edit_num
from lina
left join linv
on linv.lineage_name = lina.lineage_name
group by linv.owner, linv.name
order by 3 desc
This query is reporting ~500,000 A rows without a version. But when I compress none are removed. Before I compress I am:
- Disconnecting all users
- Prohibiting new connections
- Ensuring sde.table_locks has no rows
So, I am not sure what I am missing. Is there something wrong with my assumption? Or is my query flawed?
Thanks!