Re: Query for sequencial scan
Serafim Fonseca (inf@dpx20.growela.pt) wrote:
: Hello,
: Some time ago, someone posted a sql query to a sysmaster table
: that showed which tables were sequentially scanned.
: Is it possible to post it again?
: Thanks
: Serafim Fonseca
Here it is:
dbaccess sysmaster <<EOF
set isolation to dirty read;
select dbsname, tabname,
sum(seqscans)
from sysptprof
where seqscans > 0
group by dbsname,tabname
ORDER by 3;EOF
joe
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide"
Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998
from Prentice Hall/Informix Press. If you have debugging tips, tools, or
ideas to share, please send me some e-mail.
---------------------------------------------------------------------------