Was this page helpful?
Execution profiles are a way to group various query execution configuration options together. Profiles can be created to represent different workloads, which can be run conveniently on a single session.
The settings that an execution profile encapsulates are as follows:
load balancing policy
speculative execution policy
There are two classes of objects related to execution profiles:
ExecutionProfileHandle. The former is simply an immutable set of the settings. The latter is a handle that at particular moment points to some
ExecutionProfile (but during its lifetime, it can change the profile it points at). Handles are assigned to
At any moment, handles can be remapped to point to another
ExecutionProfile. This allows convenient switching between workloads for all
Statements that, for instance, share common characteristics.