The following example illustrates how to assign preferred access to resources to an execution object by associating it with the EC1 execution class. In this case, the execution object is a combination of application and login.
For example, if you decide the “sa” login must get results from isql as quickly as possible, issue sp_bindexeclass with the preferred execution class, EC1, so Adaptive Server grants execution preference to login “sa” when it executes isql:
sp_bindexeclass sa, LG, isql, EC1
This statement specifies 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
