COUNT(*)
to count the number of matches for a query:
COUNT
:
The field being counted, in this case
rating
, must be indexed as
fast.COUNT
was pushed down, look for a ParadeDB Aggregate Scan
with value_count
in the EXPLAIN
output:
Expected Response