Hi. Is there a way to apply partial case statement ? Use case : case when followed by else scans all the documents whereas the same condition when applied in where doesn't do full scan.

sum(case when column_a = 1 then 1 else 0 end)

vs

count(*) where column_a = 1

Follow-up : Is there a way to apply coalesce ?

I think I'm missing something...why can't you do:

select sum(column_a)
from ...

you can use filter with aggregation

I do remember adding, yes

can you point us to that..