Rule Types

The following table defines the types of rules that you can set up.

Rule Type	Description
Prepare	Rules evaluated and applied during the pre-execution phase for a query, before it is submitted to a resource pool. A variety of actions can be taken at this stage, including imposing limits on execution time and memory, setting query priority, or selecting a resource pool.
Runtime	Rules evaluated and applied while the query is running. These rules are processed for long-running queries only, at 5-second intervals. If a query runs to completion in less than 5 seconds, these rules are not applied at all. Only a few different actions can be taken. For example, long-running queries can be intercepted and aborted, the priority of queries can be reset, queries can be moved to different pools, and query activity can be logged.
Completion	Rules evaluated and applied once after all query execution steps are completed or stopped for some reason. The only actions available at this stage are related to logging.

Parent topic:Creating Rules

Rule Types ​