NOEXEC option

Generates the optimizer query plans instead of executing the plan.

ON or OFF

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

OFF

When determining how to process a query, the IQ optimizer generates a query plan as a map of how it plans to have the query engine process the query. If this option is set ON, the optimizer sends the plan for the query to the IQ message file rather than submitting it to the query engine. This option only affects queries or commands that include a query.

Note that when the EARLY_PREDICATE_EXECUTION option is ON, IQ executes the local predicates for all queries before generating a query plan, even when the NOEXEC option is ON. The generated query plan is the same as the runtime plan.