SUM
computes the total over a specific column:
The field being summed, in this case
rating
, must be indexed as
fast.SUM
ignores null values. Use COALESCE
to include them in the final sum:
SUM
was pushed down, look for a ParadeDB Aggregate Scan
with sum
in the EXPLAIN
output:
Expected Response