The set plan load command activates and deactivates the association of queries with stored abstract plans.
To start the association mode using the default group, ap_stdin, use the command:
set plan load on
To enable association mode using another abstract plan group, specify the group name:
set plan load test_plans on
Only one abstract plan group can be active for plan association at one time. If plan association is active for a group, you must deactivate the current group and start association for the new group, as shown here:
set plan load test_plans on go /*some queries*/ go set plan load off go set plan load dev_plans on go
The use of the use database command while set plan load is in effect disables plan load mode.