QUERY_PLAN option

Function

Specifies whether or not additional query messages are produced.

Allowed values

ON or OFF

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.

Default

ON

Description

When this option is turned ON, Sybase IQ produces messages about queries. These include messages about using join indexes, the join order, join algorithms for the queries, and columns being extracted using the data extraction options. 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”