RT
select
sch.name 模式名 ,
obj.name 对象名字 ,
st.t_flag 属性类型T表C列I索引,
st.n_distinct 唯一值数量 ,
st.last_gathered 收集时间,
case when (st.t_total = 0 or t_flag='T') then 100 else trunc(st.n_smaple*100/st.t_total) end 采用百分比
from
(
SELECT ID, T_FLAG, last_gathered, t_total, n_smaple,n_distinct FROM sysstats
UNION ALL
SELECT ID, T_FLAG, last_gathered, n_total, n_smaple,n_distinct FROM SYSMSTATS
)
ST ,
sysobjects obj,
sysobjects sch
where
sch.id =obj.schid
and st.id =obj.id;
用这个sql试试
您可以看下这篇文档,里面有很多统计信息相关的字典等