tony edwards (tony.edwards@bellsouth.co.nz) wrote:
: Hi,
:
: Does anyone know if the seqscans in an onstat -p increments for
: sequential scans on temporary tables ?
: Cheers, Tony.
I don't think so. I've used a script similar to one posted on this
thread to watch my scans, and I've seen that the results of the script
does not include temp tables, and the script totals equal the onstat -p
numbers.
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.
---------------------------------------------------------------------------