I have 10 Billion records. and there are only around 10 types. But the query is not showing the result. I already created an index. Is there any best way to fetch distinct data with a count.
Index : CREATE INDEX
Query : select type_,count(meta().id) as counts
from data group by type_;