Summary information |
|
---|---|
Default value |
10 |
Range of values |
0 – 1000 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
Query Tuning |
The optimization timeout limit parameter specifies the amount of time Adaptive Server can spend optimizing a query as a fraction of the estimated execution time of the query.
A value of 0 indicates there is no optimization timeout.