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