opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

✨ optimize `COUNT(1)`

Open joocer opened this issue 1 year ago • 0 comments
trafficstars

Aggregation on any literal could be rewritten.

Count(lit) = count() Max(lit) = lit Min(lit) = lit AVG(lit) = lit Sum(lit) = lit x count()

joocer avatar Aug 02 '24 17:08 joocer