optimization timeout limit

Summary information

Default value

10

Range of values

0 – 1000

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Query Tuning

optimization timeout limit specifies the amount of time, as a fraction of the estimated execution time of the query, that Adaptive Server can spend optimizing a query.

A value of 0 indicates there is no optimization timeout.