abstract plan cache

Summary information

Default value

0

Range of values

0–1

Status

Dynamic

Display level

Comprehensive

Required role

System Administrator

abstract plan cache enables caching of abstract plan hash keys. By default, caching is not enabled. For more information, see Chapter 31, “Creating and Using Abstract Plans,” in the Performance and Tuning Guide. abstract plan load must be enabled in order for plan caching to take affect.