Sets a time limit so that the optimizer can disallow very long queries.
0 to 232 - 1 minutes
0 (disabled)
Can be set at the session (temporary), user, or PUBLIC level.
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.