Informix Query Plan

Question

How can I get a query execution plan in Informix?

I need something similar to what I get in Oracle s explain planor SQL Server s set showplan_all on.

I am connecting to a .NET application (using IBM.Data.Informix) if this is important.

Thanks!

Answer 1

In your SQL, you can:

• execute SET EXPLAIN ON;This will continue until you disable or execute the equivalent statement OFF. It works, at least in version 7, it can even work in version 5.
• (v9 ), .. SELECT {+EXPLAIN} foo, bar FROM .... SELECT --+EXPLAIN \n foo bar ... SQL ( a-comment, ). SELECT.

. $INFORMIXDIR.

Answer 2

Informix?

, v10, [ SET EXPLAIN].