procedure deferred compilation

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.