Sequential Scans (David)

DATABASE sysmaster;

SELECT

stn.dbsname[1,15],

stn.tabname[1,18],

sti.ti_nptotal *

(

select pagesize

from sysdbspaces

where name = dbinfo('dbspace', sti.ti_partnum)

)/1024/1024 mb_total,

sti.ti_nrows,

spp.seqscans

FROM systabnames stn, systabinfo sti, sysptprof spp

WHERE stn.partnum = sti.ti_partnum

AND stn.partnum = spp.partnum

AND spp.seqscans > 0

ORDER BY mb_total DESC, spp.seqscans DESC;