ESTIMATEDSQLCOST threshold
The ESTIMATEDSQLCOST threshold specifies the maximum estimated cost that is permitted for DML activities.
- Type
- Activity
- Definition domain
- Database, service superclass, service subclass, work action, workload, and statement
- Enforcement scope
- Database
- Tracked work
- See the information later in this topic
- Queuing
- No
- Unit
- Estimated SQL cost expressed in timerons
- Predictive or reactive
- Predictive
This threshold tracks the following activities:
- DML activities that are issued at the coordinator member. This includes DML activities that originate from IMPORT, EXPORT and other CLP commands.
- Nested DML activities that are invoked at the coordinator member. Nested DML activities that are issued internally by the data server, such as internal SQL, are unaffected by this threshold. For information about the activities that fall under a work class with the DML work type, see Work identification by type, cost, or data accessed with work classes.