Any user can set limits on the amount of time spent processing
a particular query. Users with DBA privileges can give certain users’ queries
priority over others, or change processing algorithms to influence
the speed of query processing.
Setting Query Time Limits
Set the MAX_QUERY_TIME option to limit the time a query can run. If a query takes longer to execute than the MAX_QUERY_TIME , Sybase IQ stops the query with an appropriate error.