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 cache enables caching of abstract plan hash keys. See Chapter 12, “Creating and Using Abstract Plans” in the Performance and Tuning Series: Query Processing and Abstract Plans. abstract plan load must be enabled for plan caching to take effect.
