abstract plan cache enables caching of abstract plan hash keys.
See Performance and Tuning Series: Query Processing and Abstract Plans > Creating and Using Abstract Plans.
|
Summary Information |
|
|---|---|
|
Default value |
0 (off) |
|
Range of values |
0 (off), 1 (on) |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Query Tuning |
abstract plan load must be enabled for plan caching to take effect.