-
Title
How can I set a timeout limit for the execution of my queries? -
Description
How can I set a timeout limit for the execution of my queries?
-
Resolution
A timeout limit for the execution of a query can be set by going to Options | Tuning Lab | Execution | SQL Termination criteria | click "Cancel execution by the user defined time (mins/secs):" radio button. A defined time limit can be entered in the box to the right of this option.
-
Additional Information
Cancel execution by the user defined time (mins/secs)
Cancels SQL statements that run longer than a specified time. If your original statement takes a long time to execute and there are many alternative statements, executing all statements may take considerable time. In that event, consider setting an aggressive user defined termination time. If the original SQL takes 1 hour, try a 5 minute termination time. If no alternative statements execute in under that period, raise the termination time to 10 minutes, etc.