Abstract plan groups

When you first install Adaptive Server, there are two abstract plan groups:

A System Administrator can enable server-wide plan capture to ap_stdout, so that all query plans for all queries are captured. Server-wide plan association uses queries and plans from ap_stdin. If some queries require specially-tuned plans, they can be made available server-wide.

A System Administrator or Database Owner can create additional plan groups, copy plans from one group to another, and compare plans in two different groups.

The capture of abstract plans and the association of abstract plans with queries always happens within the context of the currently-active plan group. Users can use session-level set commands to enable plan capture and association.

Some of the ways abstract plan groups can be used are:

See Chapter 31, “Creating and Using Abstract Plans,” for information on enabling the capture and association of plans.