abstract plan cache

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.