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 analyze, 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").
The "SET EXPLAIN ON"-Statement shows the usage of "INDEX PATH" when executing the queries. But there are a lot of seqscans on specific tables.
I like to put the following question:
How can I retrieve information about the SQL-Statement, that cause the sequential scan on a table?
Any help and suggestions would be appreciated.
Thanks in advance!