The following example illustrates how to assign preferred access to resources to an execution object by associating it with EC1. In this case, the execution object is a combination of application and login.
The syntax for sp_bindexeclass is:
sp_bindexeclass object_name, object_type, scope, class_name
Suppose you decide that the “sa” login must get results from isql as fast as possible. Issue sp_bindexeclass with the preferred execution class EC1 to tell Adaptive Server to give execution preference to login “sa” when it executes isql:
sp_bindexeclass sa, LG, isql, EC1
This statement stipulates that whenever a login (LG) called “sa” executes the isql application, the “sa” login task executes with EC1 attributes. Adaptive Server improves response time for the “sa” login by:
Placing it in a high-priority run queue, so it is assigned to an engine more quickly
