optimize temp table resolution allows stored procedures that reference temporary tables created outside the procedure to not require recompiling for each execution.
|
Summary Information |
|
|---|---|
| Default value | 0 (off) |
| Valid values | 0 (off), 1 (on) |
| Status | Static |
| Display level | Comprehensive |
| Required role | System administrator |
| Configuration group | Query Tuning |
Trace flag 299 previously supported this functionality.