Adaptive Server versions 15.7, ESD #2 and later allow you to create user-defined
optimization goals.
User-defined optimization goals allow you to:
- Create a new optimizer goal
- Define set of active criteria
- Activate the goal at the 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.