How do I find out the query plan in Informix?

Posted in 1997

Gregory Trubetskoy — Wed, 12 Feb 1997 13:05:20 -0500 — source: Informix-list mailing list archive (1991-1998)

Sorry if this is a dumb question - I'm evaluating Informix workgroup server. (i386 NT) How does one find out what the query plan was for a statement/procedure? On SQL Server you can do SET SHOWPLAN ON (or something similar) and it will show the access method, wether it created a temp table and so forth. The only thing I found on Informix was SYSPROCPLAN table, but I can't make any sence out of it. Could someone point me in the right direction? Thanks a lot, Gregory.