Adaptive Server versions 15.7 ESD #2 and later allow you to create user-defined optimization goals (a set of all active optimizer criteria), which allow you to:
Create a new optimizer goal
Define a set of active criteria included in the goal
Activate the goal for a server, session, procedure, and query level
Dynamically change the goal content without disconnecting and reconnecting the client session
Once you create the user-defined optimization goals, you can invoke them at the server level or for a user session.
