Summary information |
|
---|---|
Default value |
1(enabled) |
Range of values |
0 – 1 |
Status |
dynamic |
Display level |
|
Required role |
System administrator |
Configuration groups |
Query tuning |
When this parameter is enabled, compiling of statements that reference local variables or temporary tables inside a stored procedure is postponed to execution time, so that the optimization of those statements can use runtime values, instead of estimations or magic numbers.