You can export optimization settings, such as set plan optgoal and
set plan optcriteria, using set export_options on.
Optimization settings are not local to the stored procedure; they apply to the entire user
session.
Note:
By default, set export_options is enabled for login triggers.