数据库维护---查看索引使用空间的大小

==================分片的索引分片显示============================

select
st.dbsname databasename,dt.tabname,di.idxname,sd.name dbs_name,
di.levels,sin.ti_nextns extents,
sin.ti_nptotal nptotal, format_units(sin.ti_nptotal,sd.pagesize) total_size,
sin.ti_npused npused, format_units(sin.ti_npused,sd.pagesize) used_size
from sysmaster:systabnames st, sysmaster:sysdbspaces sd,sysmaster:systabinfo sin,
demodb:sysindexes di,demodb:systables dt
where sd.dbsnum = trunc(st.partnum/1048576)
and dt.tabid>99
and di.idxname = st.tabname
and dt.tabid=di.tabid
and st.partnum=sin.ti_partnum
and st.dbsname='demodb'
order by 2,1,3;

==================分片的索引合并显示============================

select
st.dbsname databasename,dt.tabname,di.idxname ,
max(di.levels) levels,max(sin.ti_nextns) extents,
sum(sin.ti_nptotal) nptotal, format_units(sum(sin.ti_nptotal),max(sd.pagesize)) total_size,
sum(sin.ti_npused) npused, format_units(sum(sin.ti_npused),max(sd.pagesize)) used_size
from sysmaster:systabnames st, sysmaster:sysdbspaces sd,sysmaster:systabinfo sin,
demodb:sysindexes di,demodb:systables dt
where sd.dbsnum = trunc(st.partnum/1048576)
and dt.tabid>99
and di.idxname = st.tabname
and dt.tabid=di.tabid
and st.partnum=sin.ti_partnum
and st.dbsname='demodb'
group by 1,2,3
order by 8 desc;