QUERY_PLAN option

Function

Specifies whether or not additional query plans are printed to the Sybase IQ message file.

Allowed values

ON, OFF

Default

ON

Scope

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.

Description

When this option is turned ON, Sybase IQ produces textual query plans in the IQ message file. These query plans display the query tree topography, as well as details about optimization and execution. When this option is turned OFF, those messages are suppressed. The information is sent to the <dbname>.iqmsg file.

See also

“QUERY_DETAIL option”

“QUERY_PLAN_AS_HTML option”

“QUERY_PLAN_AFTER_RUN option”