Re: locating sequential scans

Posted in 2005

Superboer — 18 Aug 2005 00:06:28 -0700 — source: Usenet: comp.databases.informix

oncheck -pT <thefoundnumber> or dbaccess sysmaster <<! select * from systabnames where partnum = <your number>! Superboer. BTW looking for seqscans if in your onconfig: TBLSPACE_STATS 1 dbaccess sysmaster <<! select * from sysptprof whereseqscans > <somenumber you make up> !