A subset of collection operators are known as aggregation operators because they evaluate a collection to compute one value. These aggregation operators are as highlighted:

When these aggregations are applied through the Enterprise Data Connector in a Rulesheet set to Extend to Database, the performance effect against large tables can be minimized by performing non-conditional actions that force the calculations onto the database. For an example of this, see Optimize aggregations that extend to database