SYSSTATS视图

https://eco.dameng.com/document/dm/zh-cn/pm/dm8-admin-manual-appendix.html#12.%20%E7%B3%BB%E7%BB%9F%E4%BF%A1%E6%81%AF

select * from (
select o.owner,o.object_name,b.column_name,b.column_id,b.data_type,s.t_total,s.n_smaple,s.n_distinct,s.n_null,s.n_buckets,b.histogram,s.last_gathered
from sysstats s 
inner join dba_objects o on s.id=o.object_id
inner join dba_tab_columns b on o.owner=b.owner and o.object_name=b.table_name and s.colid+1=b.column_id 
where o.owner='XXX' 
and o.object_name='XXX' 
and o.object_type='TABLE')
order by b.column_id;