Re: How do I find out the query plan in Informix?

Hi, Yes, it is real similiar. You'll need to SET EXPLAIN ON from whatever application that you are using. You should then see a sqlexplain.out file in your home directory on the dbserver machine. This is where the query plans get dumped. -Bill } } 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. } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com