数据库上可能创建了若干索引,但是有的索引可能几乎不用,用本身就是多余垃圾的索引,反而影响insert,update,delete的性能。
所以建议找到这些索引,可以考虑优化掉:
Dbaccess sysmaster
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,
pagreads diskreads,bufreads bufreads,bufwrites bufwrites,pagwrites diskwrites,
pagreads + pagwrites disk_rsws,
from sysmaster:systabnames st, sysmaster:sysdbspaces sd,sysmaster:systabinfo sin,
demodb:sysindexes di,demodb:systables dt,sysmaster:sysptprof p
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'
and p.partnum=st.partnum
order by 2,1,3;