optimization timeout limit

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.