opteryx
opteryx copied to clipboard
✨ optimize `COUNT(1)`
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()