I've an application that stores a lot of data in my database-tables
(Informix DS 9.30). As there are some problems with the performance, I
yze, among other things, the parameter seqscans (given by onstat -p) and
which tables causes them (script: "select tabname, seqscan, nrows from
sysptprof a, sysptnhdr b where seqscans > 100 and dbsname = 'DB' and
a.partnum=b.partnum order by seqscans desc").
How can I retrieve information, which specific SQL-Statement cause the
sequential scan on a table?
Any help and suggestions would be appreciated.
Thanks in advance!