procedure deferred compilation

procedure deferred compilation enables or disables compiling statements that reference local variables or temporary tables inside a stored procedure until execution time, so that the optimization of those statements can use runtime values, instead of estimations.

Summary Information

Default value

1(enabled)

Range of values

0 – 1

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration groups

Query tuning