Alphabetical listing of configuration parameters  abstract plan dump

Chapter 5: Setting Configuration Parameters

abstract plan cache

Summary information

Default value

1 (on)

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. By default, caching is not enabled. For more information, see Chapter 16, “Creating and Using Abstract Plans” in the Performance and Tuning Guide: Optimizer and Abstract Plans. abstract plan load must be enabled in order for plan caching to take effect.





Copyright © 2005. Sybase Inc. All rights reserved. abstract plan dump

View this book as PDF