optimization goal  page lock promotion HWM

Chapter 5: Setting Configuration Parameters

optimization timeout limit

Summary information

Default value

10

Range of values

1 – 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.





Copyright © 2005. Sybase Inc. All rights reserved. page lock promotion HWM

View this book as PDF