MAX_QUERY_TIME option

Function

Sets a time limit so that the optimizer can disallow very long queries.

Allowed values

0 to 232 - 1 minutes

Default

0 (disabled)

Scope

Can be set at the session (temporary), user, or PUBLIC level.

Description

If the query runs longer than the MAX_QUERY_TIME setting, Sybase IQ stops the query and sends a message to the user and the IQ message file. For example:

The operation has been cancelled -- Max_Query_Time exceeded.

MAX_QUERY_TIME applies only to queries and not to any SQL statement that is modifying the contents of the database.