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 |