Making execution class assignments indiscriminately does not usually yield what you expect. Certain conditions yield better performance for each execution object type. Table 5-5 indicates when assigning an execution precedence might be advantageous for each type of execution object.
Execution object |
Description |
|---|---|
Client application |
There is little contention for non-CPU resources among client applications. |
Adaptive Server login |
One login should have priority over other logins for CPU resources. |
Stored procedure |
There are well-defined stored procedure “hot spots.” |
It is more effective to lower the execution class of less-critical execution objects than to raise the execution class of a highly critical execution object. The sections that follow give more specific consideration to improving performance for the different types of execution objects.
